Oracle

RAC Split-Brain resolution voting algorithm learned that Split Brain is a kind of surgery for epilepsy. Doctors believe that epilepsy is caused by the brain's "abnormal discharge. To prevent "abnormal discharge" from spreading to the entire brain

How to find out the record V $ SESSION that causes enq: TX-row lock contention has the following four columns to record the row that causes suspension when enq: TX-row lock contention occurs. Www.2cto.com ROW_WAIT_OBJ # NUMBER -- OBJECT_ID

Case when syntax in SQL statements and similar methods in Oracle I. Basic Concepts and examples case when is the syntax of SQL statements, rather than the language www.2cto.com of a specific database I: select num, name, (case classnowhen '1' Class 1

Oracle renaming tables and operations on copying table information Java code oracle modifying table name alter table_name rename to new_table_name; www.2cto.com oracle Inserting Data Based on queries Insert is a common statement in T-SQL, insert

Introducing from the hard drive installation of OracleLinux6.3: This blog post focuses not only on installing OracleLinux6.3, but also on a small error that has plagued me for several days. www.2cto.com scene: A blank hard disk, a tool U disk, disk

Differences between nocatalog and catalog in RMAN: The nocatalog method uses the control file as the catalog. Each backup must write a lot of backup information into the control file. More and more backup information will appear in the control file,

Record local and remote oracle backup in linuxClient server environment: rhel-server-5.4-x86_64 + oracle10g remote backup server environment: windows server 2008 network environment: formal server on the internet, remote backup server on the

How to Use the BIRT sample program to connect to the Oracle database and use BIRT for a report, which can be displayed during production and debugging, but cannot be displayed in the birt sample program and cannot be connected to the database, it is

Oracle 11g (11.2.0) manual database creation various versions on the Internet are unsightly behind, and their own searches are exploding, but Li Zheng discussed someI still know that no matter how good I know it, it is better to cooperate with

Common maintenance commands for Oracle 10g RAC: status of all instances and services [oracle @ vzwc1 ~] $ Srvctl status database-d zwc Instance zwc1 is running on node vzwc1 Instance zwc2 is running on node vzwc2 status of a single Instance [oracle @

Oracle Data Guard (iii) Switchover 1. check the status of the Primary database SQL> select switchover_status from v $ database; Role Switching can be performed only when the status is "TO STANDBY" or "SESSIONS ACTIVE. 2. switch the role SQL of the

How to synchronize two databases in Oracle (using the materialized view) (oracle snapshot instance) I. Technical implementation details unless otherwise specified, the following SQL commands are run under the SYSETM user of the database ora_db2.

Oracle OWI wait Event History View and related views the wait event view provided by Oracle allows us to obtain detailed information about the specified session and instance-level wait events. These views are v $ session_wait, respectively, v $

Commands for setting Oracle archive mode: 1. log on to the database as sysdba 2. archive log list; view database and archive information; 3. Shut down the database normally, such as using shutdown immediate; 4. Start the database by loading. startup

Database Learning (5) -- create and update a data table 2 use indexes in practical applications. Appropriate indexes are created for the data table to accelerate query efficiency. An index is a pointer to data in a data table. By creating an

View and modify the character set of the oracle server and client. 1. What is the oracle character set? The Oracle character set is a collection of symbols for the interpretation of the byte data. It can be divided into different sizes and have an

Oracle implicit data conversion rules The following rules govern the direction inwhich Oracle makes implicit data type conversions (in oracle, if different data types are associated, if The data is not explicitly converted, it will implicitly

Rac creates a data file in a non-shared location. oracle 11g 11.2.0.1linux server 64-bit 5.4 node1: Creates a data file '/tmp/rman. dbf' is not stored in the shared disk. Then, a table casd is created and data is added. In this case, the following

Basic syntax and example of Oracle exp and imp usage: 1. EXP: There are three main methods (complete, user, table) 1. Complete: exp system/manager buffer = 64000 FILE = C: \ FULL. dmp full = Y if you want to perform FULL export, you must have

[Oracle] AWR Report Analysis Method AWR data mainly consists of two parts: 1) system load and performance statistics stored in the memory, mainly through the v $ View query; 2) the mmon Process regularly saves AWR data in memory to the SYSAUX