Database Administrator

1. insert into select statement Statement format: Insert into Table2 (field1, field2,...) select value1, value2,... from Table1 The target table Table2 must exist. Because the target table Table2 already exists, We can insert constants in addition

During the previous installation, diskgroup used the external redundancy level. Now we want to change it to the normal redundancy level. However, since diskgroup Redundancy cannot be adjusted once it is created, it can only be rebuilt. The procedure

-- 1. Check the Software Installation/*Binutils-2.15.92.0.2-13.EL4Compat-db-4.1.25-9Compat-libstdc ++-296-2.96-132.7.2Control-center-2.8.0-12Gcc-3.4.3-22.1.EL4Gcc-c ++-3.4.3-22.1.EL44Glibc-2.3.4-2.9Glibc-common-2.3.4-2.9-- Gnome-libs-1.4.1.2.90-44.1

When I started the test database in the morning, I found the following problems:The database version is 11.2.0.3.SQL> startupOracle instance started. Total System Global Area 1653518336 bytesFixed Size 2228904 bytesVariable Size 1140854104

I. Hardware Detection1. Memory detection Oracle11g requires a minimum of 1 GB memoryCommand: grep MemTotal/proc/meninfo2. swap space detection usually has 1.5 times of swap spaceCommand: grep SwapTotal/proc/meninfo3. temporary directory/temp

What is the restoration method for MySQL InnoDB table structure? The following describes in detail the restoration steps of the MySQL InnoDB table structure. If you are interested in this, take a look. MySQL InnoDB Table Structure

In RedHat 5, raw devices are managed through udev. Then, how does udev know the raw device through MAJOR and MINOR. If we only write: ACTION = "add", KERNEL = "sda", RUN + = "/bin/raw/dev/raw/raw1% N" Therefore, Udev cannot identify raw devices and

In mysql, a Single point of failure (SPOF: Single pointof failure) occurs in a simple mysql Master/Slave configuration. This fatal problem can be avoided through the mysql MMM project. What is mysql MMM? The official explanation is as follows,

Environment: 192.168.1.8 (DR, real server) 192.168.1.88 (real server) 192.168.1.188 (real server)1. DR installation Configuration:(1) install IPVSADMYum install ipvsadm(2) bind a VIP:Ifconfig eth0: 0 192.168.1.200 broadcast 192.168.1.200 netmask 255.

Archive ModeActiveLog corruption ActiveIndicates that the log has been switched and may have been archived. It may also indicate that the dirty blocks in the log have not been archived.DBWRWrite Disk View archiving path SQL>Show parameter recovery  

1. instance recoveryThe system automatically recovers when the instance is restarted.Judgment basis: the scn of the data file is inconsistent with the control file.Steps:(1) use the online redo log to roll the data to the SCN that is consistent with

1: fault description Because it is developed in linux, phpmyadmin is used to directly modify the mysql field to generate the modified SQL statement, copy it to word (libreoffice), and submit it to the project management system, My colleagues cannot

Someone is looking for SQL Server to store Email data on the Internet. In fact, SQL Server provides OLE DB Provider to access Exchange. Microsoft ole db Provider for Exchange publicly stores data in Microsoft Exchange 2000 Web Store in tabular form.

Recently, I encountered a performance problem caused by dynamic sampling, which is a bit difficult for me to understand. by reading the document and doing experiments, I will summarize it as follows:Let's take a look at the Online Document's

1.fedora17system and mysql-5.1.58.tar.gz download Linux RedHat fedora17 Gonme System: http://download.fedoraproject.org/pub/fedora/linux/releases/17/Live/i686/Fedora-17-i686-Live-Desktop.iso Download

After reading the mongodb authoritative guide, it is more appropriate to use the replica set for read/write splitting, and the general system is enough to use it. It is easy to find. If you do not describe it, you can only describe the key

In plsql development, some big data table data processing is involved. For example, the records of a table with over million records are processed and converted into another table or several tables. The conventional operation method can be

1. view the Linux host system Character Set echo $ LANG En_US.UTF-8 The second ssh client character encoding is set to default by default, as long as you change to the specified UTF-8 to display Chinese on the terminal. SecureCRT settings: (After

1. A ora-14452 error occurred while deleting the user. SQL> drop user ggtransfer2 cascade; Drop user ggtransfer2 cascade * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-14452: attempt to create, alter or drop an index on

Database instance: Each running Oracle database corresponds to an oracle Instance, also known as a routine. When a database on the database server is started, oracle allocates a memory interval for it, called the system global zone (SGA), and then