Database Administrator

This article details how to implement dual-machine hot backup for MySQL databases. 1. There is no Incremental backup mechanism for MySQL databases. Backup is a big problem when the data volume is too large. Fortunately, the MySQL database provides a

Programmers often write on their resumes to familiarize themselves with Oracle and SQL Server. So it is very likely to be asked about the difference between Oracle and SQL Server, and many people are being asked. I have never thought about this

Use FreeTDS in Linux to access the Microsoft SQL Server database Download freetds http://www.freetds.org/ With PHP's support for MSSQL: ./Configure -- with-mssql =/usr/local/freetds If: Configure: error: Directory/usr/local/freetds is not a

Taking part in Oracle's open-source technology day, I have no contact with Oracle db and open-source. I have always been a fan of ms products and cisco, but I am free of charge to learn more, it is also good to broaden your knowledge. In Oracle's

Introduction Oracle Database 10 Gb provides five new flash back functions: Flash back version query, flash back transaction query, flash back deletion, flash back table and flash back database. Oracle Database 11gR1 provides an interesting new flash

MySQL released the latest stable version 5.1.34 of the 5.1 series this morning. This is the fourth version after the official GA version of The November 26 last year series was released in 5.1. The previous version is 5.1.33 of. We recommend that

PhpWhen the script is running, the data is stored in the memory,ArrayAndMysqlThe result set is a common data type. The memory usage of the two data types is tested.  Research and useMemory_get_usage (true)View memory

Oracle10g manually create a database stored in ASMProject Process:0. Add two SCSI hard disks to the computer.1. Install ASM2. Create two ASM disk groups: GROUP1 and GROUP23. Create a database. First, create a parameter file and save it as $

OCR is like a Windows registry that stores all configuration information related to the cluster and RAC database. It is also a public configuration, that is, multiple nodes share the same configuration information. Therefore, this configuration

Oracle Hot Backup refers to copying data files when they are in use. DBWR is also in progress during the replication process. Therefore, the backup may result in "inconsistent" backup: Articles: Oracle recovery Internal principles

Oracle RAC backup and recovery OCR For how to add and delete Oracle rac ocr, see: Voting disks Backup Recovery reference: 1. OCR supports two backup methods: automatic backup and manual backup. Automatic Backup: Oracle Clusterware automatically

Oracle RAC migration OCR For how to add and delete Oracle rac ocr, see: Oracle RAC backup and recovery OCR reference: If you want to change an existing ocr location or a faulty ocr location, you can use the following procedure to migrate the ocr. 1.

In the absence of visual tools to monitor database performance, common scripts come in handy. Below are a few scripts related to Oracle performance for your reference. The following scripts are successfully tested in Oracle 10 Gb, and Oracle 11 GB

Platform solaris, Oracle10202Error Information: Terminate output from the derivative process.Information :----------------------------------Information: An exception occurs during the operation: makeException error name: MakefileExceptionException

Scenario Description: A friend asked, ms SQL server will back up the database to restore to other machines is very convenient, basically is a silly operation, Oracle control files, parameter files a bunch of things, I think the restoration is very

When sorting operations, re-indexing, and other large operations cannot be completed in the memory, the temporary tablespace will facilitate sorting. Generally, temporary tablespace is shared by multiple users and multiple sessions. The quota cannot

Environment Oracle 11.2.0 + SQL Plus Problem Write a function as required: add 200 of the employees whose salaries are lower than the average wage in the scott. emp table, and return the total number of employees who have changed their salaries. An

Enter sqlldr. If no parameters are followed, a simple description of all command line parameters and their default values are displayed. (You can also query some parameters quickly when you forget them ): Valid Keywords: Userid -- Oracle

The temporary table of Oracle only exists in a session or transaction lifecycle. The data in the temporary table is only visible to the current session. When the session exits or the user commits a commit or rollback transaction, the data in the

BYS @ bys1> set arraysize 200BYS @ bys1> set autotrace traceonly statBYS @ bys1> select * from test2 order by 3;72465 rows selected.Elapsed: 00:00:00. 57Statistics----------------------------------------------------------1 recursive cballs0 db block