Oracle

In this section, we build a slightly more complex replication environment, and this time we will no longer replicate between two databases, add a new database, and synchronize data between three databases. I. Description of requirements Set the

One, rollback (ROLLBACK) and undo (undo) Rollback and roll forward are important means of ensuring that data in an Oracle database is in a consistent state. Before the 9i version Oracle uses rollback segments in the database to implement

Oracle 11g Dataguard Duplicate physical standby configuration (i) Create configuration for physical repositories # ver:1.5 Fifth time modified # modify:2013.8.16 # Author:koumm Description The installation of this article is configured with

For DML statements, as long as the data block is modified, the Oracle database retains the modified data in the undo segment, while the undo segment is saved in the Undo table space. From Oracle 9i, there are two ways to manage undo: Automatic Undo

Starting with Oracle 10g, Oracle provides a new feature for automatic SGA management (ASMM, or automatic Shared Memory Management). The so-called asmm, means that we no longer need to manually set the shared pool, buffer pool and other memory pool

EXPDP's Network_link As we know, EXPDP the default is to export the local database, the Network_link is to export the remote database to the local server, and its steps are as follows: Terminology Description: SOURCE database: Remote

The specific configuration of Oracle load Balancing is described in detail in this paper. Through the client and server side of the configuration, the text of the code is more comprehensive, worthy of reference. For professional data-processing

When a sequence is invoked for the first time, it returns a predetermined value, and in each subsequent query call, the sequence produces a value that is obtained by its specified increment. 1. Create sequence The syntax format is as follows:

Data integrity refers to the logical consistency and accuracy of the data in the database. Data integrity is generally divided into 3 types: domain integrity, entity integrity, and referential integrity. Integrity constraints ensure data integrity

SELECT * from Dba_data_files; Col name format A15 Col failgroup format A20 Col path format A30 Oracle kfed and Kfod Tools description 1. Check V$asm_disk.header_status toverify that the disk header was in a ' member ' state. Check the status of

On the itpub see a forall execute update post, feel a little meaning, simple record. Previously studied INSERT statements in ForAll, found that the statement through the binding array, the way to achieve a batch binding, a run of the way, thereby

Tspitr (tablespace point-in-time recovery) is used to restore one or more tablespaces to the state of a point in the past, while other tablespaces remain in place. Tspitr Related concepts and terminology: (1) tspitr (tablespace point-in-time

Oracle Database Performance tuning the most important and frequently encountered is the efficiency of SQL execution, and the most intuitive tool for SQL efficiency is the CBO's execution plan, so how to make the CBO produce the most accurate and

Today to increase the data file, the database file name more than one point, although it can be used, but in the operating system to see the file but feel very uncomfortable, check some data, modify the method summarized as follows: 1. Close the

In Oracle 9i, data can be easily exported to a file or imported from a file. With Oracle's Management Server (Oracle Management server,oms) can be easily implemented, there are many places to explain the entire operation, but the complete guidance

1. Install Fedora2 2. Download oralce10g (www.oracle.com), general installation simply download ship.db.cpio.gz 3. untie [Oracle @oar10g oracle]$ cd/tmp [Oracle @oar10g oracle]$ GZIP-CD ship.db.cpio.gz | Cpio–idmv 4. Modify the Linux system

Oracle's stored procedures return recordsets, and the key is to use cursors. About the database of the cursor (cursor) We certainly have a lot of contact, we can use the Open,fetch,close operation to control the cursor for a variety of convenient

select * from test..TEST.TEST1 Server: Message 7356, Level 16, State 1, line 1 OLE DB provider ' oraoledb.oracle ' provides inconsistent metadata for the column. Meta data information was changed while executing. OLE DB Error Tracking

ERROR:PLS-00201: Must indicate identifier ' DATETIME ' Line:45 TEXT:AA datetime, ------------------------- No datetime types in Oracle =================================================== Error: PLS-00103: 出现符号 "("在需要下列之一时：　　　　:= . ) , @

Among the many Oracle-related issues, one of the most important is the buffer busy wait (buffer busy waiting) event. Buffer busy waiting is the most common phenomenon in i/o-bound Oracle systems, especially in the first five busy read