Database Administrator

Version 11.2.0.1.0Rac1Rac2Linux 5.3U 2.6.18-128. el5Because we need to fix a bug for testing, modify the implicit parameter on a node, and then restart it! During the testModified the parameters on rac1.Sys @ rac1> alter system set "_ gc_read_mostly_

1. References To do well, you must first sharpen your tools. Oracle official reference Document: Oracle Document. There are various documents, two of which are about oci and occi. C language: Oracle Call Interface Programmer's Guide and Oracle C ++

Environment:OS: Red Hat Linux As 5DB: Oracle 10.2.0.4 The following describes how to simulate Incomplete recovery after archiving logs are lost.1. Back up the databaseRun {Allocate channel c1 device type disk;Allocate channel c2 device type

Today, a colleague asked me to say that his local database was deleted by him by mistake, so he could not open the file. Let's take a look.SQL> conn jjw/jjwERROR:ORA-01033: Oracle initialization or shutdown in progress Warning: You are no longer

Let's first use a small table to explain which aspects should be paid attention to in the Oracle execution plan. Hr @ ORCL>SetAutotrace traceonly Hr @ ORCL>Select*FromT; When comparing the advantages and disadvantages of two SQL statements, we

Last time we introduced the new feature of Oracle 11 GB-virtual columns. Today we will introduce another new feature-read-only tables. Read-Only tables are no different from normal tables, but no DML (Insert, Update, Delete) operations can be

Db2 has two tables, master table a B is from the table, and the foreign key of B is the primary key of.Both tables of table A and table B have more than one million data records,When A record in Table A is deleted and the primary key is used as the

I. Basic ConditionsGraphic InterfaceNetworkingIt is best not to start selinux 2. Prepare the software to be installed: (this is very important. The first installation failure is because the software package is not fully loaded)Rpm-qa xxx *Yum

To uninstall a DB2 database in Linux: 1. Remove DB [delete database first](1) su-db2inst1(2) db2 list db directory(3) db2 drop db 2. Remove Instance [Delete Instance](1) su-root(2) cd /instance(3)./db2ilist(4)./db2idrop-f 3. Remove das [Delete

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

Receive the contract_no and item_no values and search for them in the inventory table. If the product:Delivered, assigned in arrival_date as the 7 days after todayOrdered. In arrival_date, the value is assigned to the month after today.If there is

1. When installing mysql2 using gem, the following error extconf. rb: 2: in 'require ': no such file to load -- mkmf (LoadError) from extconf. rb: 2 is prompted. Building native extensions. This cocould take a while... ERROR: Error installing mysql2:

After 10G R2, Oracle provides a new parameter commit_write to control the write behavior of ORACLE logs after the client commit. This parameter value has four combinations. · Immediate, wait Note: When Server process is submitted, semctl is used to

INACTIVELog corruption SQL> alter system switch logfile;  System altered. View the log status SQL>Select * from v $ log;   GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIM -------------------------------------------------

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

1. Download MySQLVersion I downloaded: mysql-5.5.22.tar.gz 2. uninstall MySQL that comes with CentOS before installation[Root @ localhost ~] # Yum remove mysql 3. Compile and install CmakeDownload cmake source package: http://www.cmake.org/files/v2.8

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

ORA-39002: invalid operation.ORA-39070: Unable to open the log file.ORA-29283: invalid file operationORA-06512: at "SYS. UTL_FILE", line 475ORA-29283: invalid file operation Solution 1: Today, when I used IMPDP to import data, I encountered "ORA-3900

1. How to enable the autotrace function of sqlplus? [Pl/SQL dev does not support this function]Log On with the sys user and perform the following steps:(1 )@? \ Rdbms \ admin \ utlxplan -- create a plan_table table(2) There is no synonym for

The storage process from Julian Dyke to test the single-core CPU performance can test the single-core CPU processing capability. By the way, I also tested SET SERVEROUTPUT ONSET TIMING ON DECLARE N NUMBER: = 0; BEGIN FOR f IN 1 .. 10000000 LOOP N: =