PHP

The following shell script is used to restore the database automatically. After the restoration is successful, the database is disabled. Because we do not need the bak slave database in the case of no exception in the Prod database. The following

Parallel DML applications have significant scalability and performance when accessing large objects in the decisionsuppsystemsystemdss environment. You cannot Parallel DML applications have significant scalability and performance when accessing

The above is a very frustrating OTL connection to the Oracle database Code, only the connection without other operations. However, I encountered some problems during compilation: an error message is generated, The above is a very frustrating OTL

ORA-12545 error during Oracle11gR2RAC connection ORA-12545 error during Oracle 11gR2 RAC connection Just installed Oracle 11gR2 RAC cluster Three nodes After creating a database, everything is normal. Then I installed an oracle client, and the

Udev can manage files stored in the dev directory. Files are generated only after the device is connected to the corresponding device, and are automatically deleted after the device is pulled out. It also allows users to add rules for repair. Udev

Solving ORA-00060: Deadlockdetected small example Solving ORA-00060: Deadlock detected small example Database Version: SQL> select * from v $ version; BANNER----------------------------------------------------------------Oracle Database 10g

MySQL multi-thread logical backup Mydumper introduction Mydumper is a multi-thread MySQL logical backup tool. The logical backup speed is very fast (compared with mysqldump) myisam MySQL multi-thread logical backup Mydumper introduction Mydumper is

The slow query log of mysql database is a very important auxiliary log for tuning, but the log format recorded by mysql by default is not friendly enough to read. The slow query log of mysql database is a very important auxiliary log for tuning, but

ORA-00600: internalerrorcode, arguments: [ktrgcm_3] ORA-00600: internal error code, arguments: [ktrgcm_3] I was planning to conduct an in-depth study on Oracle Data dictionary this evening, but when I was about to finish the research, I

Install MySQL5.6.12 in Linux source code (Cmake compilation) Install MySQL 5.6.12 (Cmake compilation) in Linux source code) 1. Install the make Compiler (default system) : Tar zxvf make-3.82.tar.gzCd make-3.82./ConfigureMakeMake install 2.

During the project process today, duplicate records exist in Oracle database tables, and duplicate data needs to be removed during display. After thinking for a long time, I finally used rank () over (partiti During the project process today,

Ubuntu12.04 (amd64) solutions to various problems after Oracle11gR2 is installed Solutions to various problems after installing Oracle 11gR2 in Ubuntu 12.04 (amd64) The previous article introduced how to install the Oracle database on Ubuntu

V $ database. CONTROLFILE_CHANGE # (indicates the last scn Number of the control file recovered from the backup. If the control file is not V $ database. CONTROLFILE_CHANGE # (indicates the last scn Number of the control file recovered from the

I found this problem in my work: in Oracle versions earlier than 10 Gb, there is a bug that PreparedStatement preprocessing is used to dynamically query data, using placeholders? Replace I found this problem in my work: in Oracle versions earlier

A few days ago, my colleague sent an SQL statement saying that the update operation was very slow. I checked that the data volume was not large. Check the execution plan and find that the execution path is incorrect. A few days ago, my colleague

Starting from 10 Gb, Oracle provides more efficient DataPump (expdpimpdp) for data import and export. The old expimp can also be used, but it is not recommended. Note Starting from 10 Gb, Oracle provides more efficient Data Pump (expdp/impdp) for

A: zwj; in the telecommunications industry in this huge data volume environment, ora-01555 error is a very common error. This error causes the application to fail. For example, this error may stop A: zwj; in the telecommunications industry in this

The control file experiment has a maximum of eight control files, at least one of which is an image of each other. If the control file is lost, the database cannot be shut down normally and cannot be started. Add control file, required The control

About ORA-01187: cannotreadfromfilebecauseitfailedverificationtests About ORA-01187: cannot read from file because it failed verification tests Environment: OEL + Oracle 11.2.0.3 + physical standby Problem description: displays the Ora-01187

One or several autonomous transactions can be defined in a transaction (outer transaction. An autonomous transaction can be committed independently without affecting the outer transaction. One or several autonomous transactions can be defined in a