NAV: SLTechnology News&Howtos > Database >

• 

  Query lock status and processing

  SELECT dob.object_name table_name,lo.locked_mode,lo.session_id,vss.serial#,vss.status,vps.spid,vss.a

  2022-06-01 05:32:37 Views: 221
• 

  Opatch apply error OPatch failed with error code 73

  1. Execute opatch apply error OPatch failed with error code 73 [oracle@ora_11g 14275605] $/ opt/oracle/product/d

  2022-06-01 05:32:37 Views: 290
• 

  Why is enterprise software system development so expensive?

  Engaged in enterprise information management for many years, people often ask how much does it cost to develop an enterprise software? In fact, this question feels difficult to answer, because no matter how you answer it, the probability of getting feedback is: "Why is it so expensive?" So today let's take a look at why enterprise software development is so expensive! First

  2022-06-01 05:32:31 Views: 212
• 

  The overall architecture and memory structure of MySQL

  A mysql overall framework: MySQL is composed of SQL interface, parser, optimizer, cache, storage engine and so on. 1. Connectors refers to interaction with SQL in different languages. 2. Management Serveices &

  2022-06-01 05:32:28 Views: 305
• 

  MySQL 5.5 mysqldump backup description

  The mysqldump client tool can perform logical backups to generate a series of SQL statements that can be executed. With this tool, you can back up one or more MySQL databases. The mysqldump command can also generate output in CSV, delimiter, or XML format

  2022-06-01 05:32:28 Views: 277
• 

  The difference between EXP and EXPDP

  1. EXPDP must be dierctory2, and EXPDP can export empty tables with no allocated space. 3. During EXPDP export, a JOB will be created and a table SYS_EXPORT_SCHEMA_01 will be generated, which will be automatically deleted after export.

  2022-06-01 05:32:27 Views: 260
• 

  RMAN-05001: auxiliary file name / u01/app/oracle/oradata/prima/system01.dbf confl

  Sql statement: alter database mount standby databaseRMAN-00571: = =

  2022-06-01 05:32:27 Views: 213
• 

  How to check whether statistics are collected successfully

  You can observe whether the collection of statistics has been completed through the LAST_ANALYZED field in dba_ind_statistics and dba_tab_statistics, and only the completed collection will be recorded in these two views. The testing process is as follows

  2022-06-01 05:32:27 Views: 245
• 

  Oracle dg delay 120 minutes to synchronize data from the main database to the backup database

  Deferred testing (backup library execution) alter database recover managed standby database delay 120 disconnect from session; real-time synchronous ALT

  2022-06-01 05:32:27 Views: 269
• 

  Settings for Oracle 11g buffer cache

  Check the size of the buffer cache: SQL > SELECT component,current_size,min_size FROM

  2022-06-01 05:32:27 Views: 246
• 

  Error initializing session database

  System structure errors may occur when reinstalling the database. At this time, just delete all the files under mysql and initialize a new system table structure / usr/local/mysql/scripts/mysql_install_db-ba

  2022-06-01 05:32:26 Views: 211
• 

  Sqluldr2 usage

  Corresponding to 32, 64-bit win and Linux platform installation step 1. Need to install oracle_client2. Copy sqluldr2_linux32_10204.bin (sqluldr2_linux64_ for 64-bit systems

  2022-06-01 05:32:26 Views: 232
• 

  Oracle standby ORA-00600: [3020] ORA-10567

  Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit ProductionRed Hat Enterprise Lin

  2022-06-01 05:32:26 Views: 219
• 

  MySQL mistakenly deletes data using binlog2sql flashback

  Query database-related configuration parameters root [test] > show global variables like 'binlog%format%';+-+-+ | Varia

  2022-06-01 05:32:25 Views: 245
• 

  [MYSQL] innodb write twice (double write) to implement parsing

  In the innodb storage engine, there is an optional technical module called doublewrite. It is controlled by the value of parameter InnoDB_doublewrite. If 0 means it is not enabled, it can be controlled by show status like "%.

  2022-06-01 05:32:23 Views: 248
• 

  [MySQL] decompose MySQL high availability solutions from the business level

  Compared with the relative service time of 9x9x6 or 9x12x5 in traditional industries, because of the real-time performance of Internet e-commerce and Internet games, the service requirements are 7 to 24 hours, and the business architecture, whether it is an application or a database, needs disaster recovery and mutual preparation. In the mysql system, it is best to use the

  2022-06-01 05:32:18 Views: 298
• 

  [Mysql] Mysql slave restarts at regular intervals

  Background: the slave replication process stops every once in a while from the HuaYun_Interface-SLAVE slave library, and zabbix sends an alarm message mysql > show slave status\ Gbot *

  2022-06-01 05:32:18 Views: 299
• 

  View historical changes to the sql execution plan

  After viewing the historical changes of the sql execution plan, oracle 10G can query the historical information of the sql execution plan through the following three views: DBA_HIST_SQL_PLANDBA_HIST_SQLSTATDBA_HIST_SNA

  2022-06-01 05:32:17 Views: 256
• 

  Log file switch

  Log file switch 1: log file switch description 2: log file switch official document 1: log file switch description select event#, name

  2022-06-01 05:32:11 Views: 229
• 

  Oracle splits comma-separated strings to implement split

  Recently, some people often ask the same sql implementation method, send it on itpub to take care of Baidu users. If a string is separated by symbols like commas or other symbols, you want to break it into columns, such as' first field, second field, thir.

  2022-06-01 05:32:07 Views: 281