Oracle

Schema-level replication can be done through DBMS_STREAMS_ADM. Maintain_schemas created, after the space-level trial of the previous table, the creation of a schema-level replication environment is relatively straightforward. The examples in this

The shared pool in the SGA consists of a library cache, a dictionary cache (Dictionary cache), a buffer for parallel execution messages, and a control structure. The size of the Shared POOL is determined by the parameter shared_pool_size. 9i, the

Oracle's memory configuration is closely related to Oracle performance. Configuration of memory is the configuration that most affects Oracle performance. Memory also directly affects the consumption of two other important resources: CPU and IO.

The analysis of logical reading of T1 table full table scanning Do an experiment to show you: Take table T1 as an example, to the segment T1 do dump 1, T1 table on a piece of data Gyj@ocm> select * from T1; ID NAME ---------- ---------- 1 AAAAA 2,

Now the mainstream database management system, both support the implementation of multiple transactions at the same time, so as to improve the operation of the database management system efficiency. Just imagine that if only one transaction is

Disclaimer: Script from Pro Oracle SQL, Pln.sql Here's just one way to view the execution plan, which is to represent a unique SQL statement by adding a note: [Oracle@maa3 ~]$ Cat Pln.sql SELECT xplan.* From ( Select Max (sql_id) keep

CREATE TABLE T0 ( Sid int NOT NULL, Sname VARCHAR2 (20) ) Tablespace test; --Loop Import data Declare MAXRECORDS constant int:=100000; I int: = 1; Begin For I in 1..maxrecords loop Insert into t0 values (i, ' Ocpyang ' | | i); End Loop;

Distributed transactions are transactions that occur between multiple databases, and in Oracle, transactions are handled in a dblink manner, and distributed transactions are much more complex than stand-alone transactions. Most relational databases

Absrtact: This paper introduces the characteristics of Jcorba and how to deploy the Java CORBA component in Oracle Application server through a Jcorba application example. The rapid development of the Internet has changed the traditional way of

1, the concept of temporary table Temporary table (Global temporary table): Online shopping for e-commerce Temporary tables are used to store private data for a session or transaction. Once a temporary table is established, its structure persists,

This article describes 8 commonly used monitoring data shell scripts. First, we reviewed some of the UNIX commands commonly used by DBAs, and explained how to execute the DBA script regularly with Unix cron. Online also has good Many similar

Oracle Data Guard, logical standby and physical standby. Here are the steps to build a physical standby environment. First, enable Force Logging Set the primary database to force logging mode. Use the following statement: View Status: Sql>

The interconnection of different database platform is commonly called the heterogeneous service of database, now each large database can realize such heterogeneous interconnection, but the specific implementation technology of each manufacturer is

In large commercial applications, the data disaster recovery backup is very important and necessary. Based on his own practical experience, the author designs a set of simple data automatic backup scheme, which can be used for reference by database

REF cursor is the reference of the result set that we define on the server side. When we open a REF cursor, no data is returned to the client, instead, the address of the data on the server will be returned to the client. This allows the user to

I am familiar with the style, I do not have much nonsense, also do not want to write a manual, I think a slightly more complex technical engineering and technical personnel the most basic ability is to do research and information collection, what

A script to start and set up a trace example we can use script to trace stored procedures, of course, to understand the specific syntax of these stored procedures and parameters of the meaning of these syntax and parameter meaning please check

Although the previous article introduced the Native_full_outer_join and no_native_full_outer_join two hint, but in fact Native_full_outer_join did not play any role, Because Oracle's optimization of the full outer join makes the new execution plan

In fact, is not a trap, just do not pay attention to, it is easy to configure errors. This article describes the possible errors caused by load_balance and failover coordination. When the service name is configured with both Load_balance and

Incomplete recovery is incomplete data recovery, incomplete recovery is the same in many ways as full recovery, they have the same basic set of commands, but some other commands are added without full recovery. There are many reasons for incomplete