PHP

I. key-value-related command keys: returns all keys meeting the given pattern using the expression *, which means to retrieve all keys using the expression mylist *, which means to retrieve all keyexists starting with mylist: confirm a key & nbs

In the previous article, du Fei introduced the page types of SQL Server data files, the system manages the table's storage structure logically Based on the 96-byte header information and the system table. In the previous article, du Fei introduced

From the definition, we can see that the Schema is a set of database objects. To distinguish each set, we need to name this set. From the definition, we can see that the Schema is a set of database objects. To distinguish each set, we need to name

ORACLE uses the ASM storage. When creating a database, the redundant attribute of the disk group uses EXTERN. To change the disk group to NORMAL, perform the following steps: ORACLE uses the ASM storage. When creating a database, the redundant

Phenomenon: GG do initdataload report error OGG-00869OGG-001992013-11-1115: 54: 18INFOOGG-03501OracleGoldenGateDeliveryforOracl Phenomenon: GG do init data load report error OGG-00869 OGG-001992013-11-11 15:54:18 INFO OGG-03501 Oracle GoldenGate

DG cannot automatically mount causes the database to fail to start properly: ORA-01157, ORA-01110, ORA-17503, ORA-15001, ORA-15001 phenomenon: after each restart of the entire CRS, D DG cannot automatically mount causes the database to fail to start

The experiment found that oracle11gR2 was used to create tables, indexes, and other objects without data. In order to save space, oracle did not allocate segment, but allocated only when there was a dml operation. The experiment found that

To avoid implicit commit or rollback, make sure that only one or more DML operations are submitted or rolled back. This prevents subsequent DCL or DDL operations from automatically submitting the previous D To avoid implicit commit or rollback, make

When using RMAN to copy a physical standby database, it is prone to errors and the error is very strange. I have summarized the issues below. 1. RMAN-04006ORA-12528, boot slave database to nomoun When using RMAN to copy a physical standby database,

By default, when we create a database in dbca, the archive will be placed under $ ORACLE_HOMEflash_recovery_area, And the size configured by oracle for FRA is 2 GB by default. If db_re By default, when we create a database in dbca, the archive will

Since image backup needs to occupy the same space as the production data file, we do not recommend this solution when the data volume is large, because this solution requires customers to spend dual storage Since image backup needs to occupy the

Configure the database environment, goldengate users, install goldengate, and perform other operations. Use the Data Pump to configure one-way Oracle-Oracle replication: -- Here I only configure Synchronization Configure the database environment,

The shared script is tested in the ORACLE11G test environment installed in LINUX. If you want to use it in your own environment, modify the relevant parameters. Use sourcehomeoracle. bash_profi The shared script is tested in the ORACLE 11g test

Oracle11g1_uardduplicate physical standby Database Configuration Oracle 11g slave uard Duplicate physical standby Database Configuration Oracle 11g slave uard Duplicate physical standby database configuration (1) physical standby database

SUSELinuxEnterpriseServer11sp1 (x86_64) requires that the Oracle database be upgraded from 11.2.0.3.0 to 11.2.0.3.7PSU (latest) with the patch 166198 SUSE Linux Enterprise Server 11 sp1 (x86_64) requires that the Oracle database be upgraded from 11.2

In Linux, add the MySQL service to the System Service of the server. 1. Understand the MySQL program path. MySQL data directory: homemysqldataMySQL program Directory: usrlo In Linux, add the MySQL service to the System Service of the server. 1. Find

The maintenance of Oracle11gRac is a little more difficult than that of 10 Gb, and there are more commands. The following is one of the solutions used in the maintenance of 11grac Votedisk, OCR, and various resources. Oracle 11g Rac maintenance is a

Due to production requirements, you need to copy the rmtel user data to rmtel_xzy, but exclude the rmtel user ( Due to production requirements, you need to copy the rmtel user data to rmtel_xzy, but exclude the rmtel user ( Scenario: Due to

In Oracle, to improve SQL Execution efficiency, You need to reduce hard parsing to achieve sharedcursor sharing. The most common method is to bind variables. In Oracle, to improve SQL Execution efficiency, You need to reduce hard parsing to achieve

MySQL master-slave synchronization build master database: IP: 192.168.18.204 edit etcmy. cnf file open log-binvimetcmy.cnflog-binapplicationmysqld MySQL master-slave synchronization build master database: IP: 192.168.18.204 edit/etc/my. cnf file