soccer_champ

• Jun 20th, 2005

The primary block size is defined by the Initiaization parameter DB_BLOCK_SIZE.

Answer Question  Select Best Answer

soccer_champ

• Jun 20th, 2005

An index cluster uses an index to maintain data within the cluster. The structure of a cluster index is similar to a normal index. Although a normal index does not store NULL key values, and inde...

Answer Question  Select Best Answer

soccer_champ

• Jun 18th, 2005

A Cluster is made up of a table, or group of tables that share the same data blocks, which are grouped togather because they share common columns and are often used together. In case of any doubt, mail me : bobby_1020@hotmal.com

Answer Question  Select Best Answer

Amit

• May 7th, 2005

Use dbms_shared_pool procedure. EXECUTE DBMS_SHARED_POOL.KEEP(OBJECTNAME); 

Answer Question  Select Best Answer

Answer for this questions is NO. Standby database must be on same version of database and same version of Operating system.

Manoj

• May 2nd, 2005

Yes you can configure your stand by server with Advance Replication provided by Oracle 8i onwards on different OS. But the Oracle version should be same.  My Current senario Primary DB is on Unix and Secondary DBs are on Windows. 

Answer Question  Select Best Answer

IRINA

• Apr 10th, 2005

The basic memory structures associated with Oracle include:  ? System Global Area (SGA), which is shared by all server and background  processes and holds the following:  o Database bu...

Answer Question  Select Best Answer

Karthikeyan.M

• Apr 6th, 2005

Block is the smallest unit of storage in the logical structure of the database where  actual table rows are stored.

Answer Question  Select Best Answer

krantideepak_v

• Apr 1st, 2005

Synonyms are used to : Mask the real name and owner of an object. Provide public access to an object Provide location transparency for tables,views or program units of a remote database. Simplify the SQL statements for database users.  

Answer Question  Select Best Answer