PHP

Recently, I received a system and went online for more than one year. During the handover, the business department reported that the disk space was full. At that time, the whole system was paralyzed and finally contacted the developer Recently, I

Configure a StreamingReplication cluster in PostgreSQL Configure a Streaming Replication cluster in PostgreSQL 2. Install PostgreSQL 1) install PostgreSQL software on the Primary and Standy nodes, installation path is/opt/pgsql-9.1.2 2) Set

TimeZone is not only an environmental variable in Oracle, but also incorporated into the data value retention process. In the Oracle field type, the field types related to the time zone are only TimeZone is not only an environmental variable in

With the continuous development and increase of the technical environment, the O & M department is facing two trends: large-scale and complex. One or two O & M personnel manage hundreds of servers in the company With the continuous development and

OracleVault is an important part of the three security technologies. Compared with the other two types, LabelSecurity, VPD (VirtualPrivateDatabase), and OracleVa Oracle Vault is an important part of the three security technologies. Compared with the

Oracle data export: Write the Creation Path file: create_dir.sqlcreateorreplacedirectorydmpdiras Oracle export data: Write the Creation Path file: create_dir. SQL create or replace directory dmpdir Homepage → Database

Run the stored procedure, which contains a temporary table. After running, I plan to delete the temporary table report ORA-14452: Anattemptwasmadetocreate, alterordropanindexonte Run the stored procedure, which contains a temporary table. After

Under normal circumstances when reporting ORA-00054, it is likely that there is an object is locked, this error is generally ldquo; resources are busy, but specify to get resources in NOWAIT mode, or super Under normal circumstances when reporting

When installing the oracle database software, we have flashrecoveryarea. If we do not select this option, the quick recovery area is disabled. When installing the oracle database software, we have a flash recovery area option. If we do not select

In many scenarios, developers often use the millisecond value from 1970-01-0100:00:00. 000 to indicate the specific time, so that data can be stored in the database as NUMBER. In many scenarios, developers are used to express the specific time in

Case study of OracleStudy-system architecture for transferring tablespaces (from Linux to AIX) on Heterogeneous Platforms: source database & nbsp .. Case study of OracleStudy-system architecture for transferring tablespaces (from Linux to AIX) on

After the server is restarted -- restart the Application Service (Confluence) -- an error is reported, indicating that the database connection fails (mysql is set to start automatically after startup) -- view the mysql database status: [root @

In some cases, you can only use a remote MongoDB instance instead of logging on to the server where the MongoDB instance is located. In this case, you can maintain the host and port list of a remote MongoDB instance on one server, then use z In some

For details about NULL values in Oracle, NULL indicates UNKNOW (unknown) and does not represent any value. For example, if a column in a row does not have any value, it is NULL. For details about NULL values in Oracle, NULL indicates UNKNOW (unknown)

Today, a friend of mine executed stopslave and got stuck. As a result, the kill process ID cannot be killed. This is because a large SQL statement is executed on the master database. After receiving the SQL statement from the slave database through

Oracle full-text index is a technology that exchanges space for time. In addition, dml operations cannot be automatically synchronized to the index, which requires regular manual maintenance. Therefore, it is not widely used. Oracle full-text index

MySQL string to date type selectstr_to_date (2014-08-2000:00:00, % Y-% m-% d % H: % I: % s); 2014-08-2000: 00: 00selectdate_format (1997-10-0422: 23: 00, % H: % I: % s); 22:23:00 MySQL string to date type selectstr_to_date (2014-08-2000:00:00, % Y-%

Tuning through case studies -- Dynamic View (v $ bh and x $ bh) v $ bh and x $ bhv $ bh: it records the usage of data blocks in the data buffer in detail, and records the detailed records of a block. V $ bh from base table x Tuning through case

Start an Oracle database instance in Linux: Step 1: Start the listener; Step 2: Start the database instance. Start an Oracle database instance in Linux: Step 1: Start the listener; Step 2: Start the database instance. Start an Oracle database

After the project was completed, we found the tragedy. By default, sqoop is used to list data tables from oracle databases. If the data accuracy is greater than 15 bits, some fields in the imported table are default. After the project was completed,