PHP

After Oracle10g, two features OFA and OMF are introduced in terms of directory structure and file management. OFA (OracleFlexiableArchitecture) is a directory structure constraint specification. After 10 Gb of Oracle, two features OFA and OMF are

Today, we used to import all the information of one Oracle user to another. For example, if one user on one machine is aa, we need to use aa on another machine. Today, we used to import all the information of one Oracle user to another. For example,

As a hotbackup tool of innodb, xtrabackup is developed by percona and widely deployed in mysql due to open source, hot backup, and physical backup. As a hotbackup tool of innodb, xtrabackup is developed by percona and widely deployed in mysql due to

To_date ( To_date ( When writing an SQL statement into a database To_date ('20140901', 'yyyymmddhhmms ') Reporting ORA-01810: The format code appears twice The reason is that the year, month, and day expressions in java are different from

In Versions later than 11.2, crs is called gi. It is very convenient to use crsctlstopcluster to shut down the resources of the entire instance, but the database instance needs to be closed separately. In Versions later than 11.2, crs is called gi.

Oracle unlock, solved ldquo; ORA-00054: resources are busy rdquo; Error Oracle unlock, solved ldquo; ORA-00054: resources are busy rdquo; Error Oracle unlock, resolving the ORA-00054: Resource busy Error 1. Procedure:-- 1. Get the session_id of

Common scenarios: When you back up the Oracle database from the server and restore the Oracle database to a local machine, you will often encounter inconsistency in the character encoding of the database. Common scenarios: When you back up the

Building Database Clone objects is a common daily O & M requirement. During actual development and testing, you often need to quickly copy a database environment containing business data. Before Building Database Clone objects is a common daily O &

The following content contains the single-instance installation manual for installing Oracle11GR2 on the IBMAIX6.1 system. This book covers the Silent Installation of oracle database software and OUI (Common Graphics The following section contains

Using sqlplus on the client allows normal users to log on, but neither system nor sys users can log on, prompting ORA-12154: TNS: unable to resolve the specified connection identifier Using sqlplus on the client allows normal users to log on, but

This article mainly records the complete process of creating a physical standby database for reference in practice. This experiment is designed to create two databases, TEST, STD_ASSG, and TEST, on the local machine. This article mainly records the

Each Oracle version has many new features and technologies. These technical features can greatly improve the Oracle operating efficiency and application performance, or improve our daily Each Oracle version has many new features and technologies.

Database locking Contention is a common problem in practice. Serious Contention may cause overall database performance degradation, or even connection failure. Actual production is as follows: Database locking Contention is a common problem in

As a toolkit launched earlier in Oracle, Statspack was first introduced in Oracle8 and has been widely used in 9i. From the development process, Statspack laid the foundation for the existing AWR As a toolkit launched earlier in Oracle, Statspack

Oracle statistics are crucial for CBO execution. RBO is based on the data structure. ddl structures and constraints classify SQL statements into different cost structure levels. CB Oracle statistics are crucial for CBO execution. RBO is based on the

: 39dbrac database Node 2, found a lot of ORA-600 errors in the alert Log, the analysis is the table test_wait statistical information error caused, re-analyze the table : 39dbrac database Node 2, found a lot of ORA-600 errors in the alert Log, the

Percona's mysql5.5.33 and mysql5.6.14 performance test comparison: The system is: rhel5.5, the test tool: sysbenchCPU is 2-core, hyper-threading, 4 Logic Percona's mysql 5.5.33 and mysql 5.6.14 performance test comparison: The system is: rhel 5.5,

Whether installed or running, the Oracle database involves various relationships with peripheral software and hardware. A healthy database system is required for smooth installation and stable operation. Whether installed or running, the Oracle

In this tutorial, we will create a MongoDB cluster with three nodes. The first node is the master node, the second node is the Failover node, and the third node is the arbitration node. In this tutorial, we will create a MongoDB cluster with three

As the most mature commercial database, Oracle database provides many security O & M tool solutions for a large number of user groups while stabilizing its core functions. Number As the most mature commercial database, Oracle database provides many