imran44

 Profile Answers by imran44 Questions by imran44

• Jan 9th, 2009

The related columns of the tables in a cluster are called the cluster key. The cluster key is indexed so that rows of the cluster can be retrieved with a minimum amount of I/O.

Dan

• Jul 9th, 2005

A cluster index is needed in support of a cluster. One is used to allow the other to exist. Much like we need an index in support of a primary key. They are not the same things.  Cluste...

Answer Question  Select Best Answer

hmounir

 Profile Answers by hmounir Questions by hmounir

• Dec 30th, 2009

A special type of clusterd table, a hash cluster, operates much like a regular clusterd table, except that instead of using a cluster index, a hash cluster uses a hashing function to store and retrieve rows in a table. 

soccer_champ

• Jun 20th, 2005

A hash cluster uses a hash algorithm, which could either be system generated or user defined, to calculate the location of a row, both for retreival and for DML.

Answer Question  Select Best Answer

Pooja Agrawal

• Nov 22nd, 2006

Database link is a schema object in one database to access objects in another database. When you create database link with Public clause, it is available for access to all the users, and if you omit this clause, then database link is privat and available only to you.

Rani Rathna

• Jul 9th, 2005

You can create a public database link for a database. All users and PL/SQL subprograms in the database can use a public database link to access data and database objects in the corresponding remote da...

Answer Question  Select Best Answer

deepikadba

 Profile Answers by deepikadba Questions by deepikadba

• Jun 7th, 2008

If a datablock is not able to store a complete row due to its less size then a row is store in another blocks & address of that row is stored in the previous block.it degrade performance of a database & there r more IOS generated.

sandhya

• Jun 27th, 2005

If any of he empty row is not sufficient to hold the row. then row is placed in multiple blocks. it happenes when the block size is small and rows are of large size. then it cause chaining. Due to chaining performance degrades and will cause more IOs

Answer Question  Select Best Answer

Sriniv@s..

• Jun 5th, 2012

Rollback segment is a database object,containing before image of data written to the database.It is used to..
:Undo changes when the transaction is rolled back.
:Recover the database in case of failures.
:Uncommitted changes made to the database,this will protected by it.

Ram

• Jul 9th, 2005

ROLLBACK INFORMATION NOTES:   Segment Name - Name of the rollback segment.  Owner - Owner of the rollback segment.  Tablespace - Name of the tablespace containing the rollback...

Answer Question  Select Best Answer

Pooja Agrawal

• Nov 22nd, 2006

The uses of Roll Back Segment are :1. Transaction Rollback2. Transaction Recovery3. Read Consistency

sri

• Aug 4th, 2005

The use of RollBack Segment is Database is - to maintain read consistency between multiple transactions.

Answer Question  Select Best Answer

gurbux

 Profile Answers by gurbux Questions by gurbux

• Jul 18th, 2010

Redo Log Files are used in case of database recovery. As redo logs contain all committed changes made to the data, they are applied from the time database crashes to recover database to point in time.

Amit

• May 7th, 2005

Redo log information are used to recover database if it get currept. 

Answer Question  Select Best Answer

gurbux

 Profile Answers by gurbux Questions by gurbux

• Jul 18th, 2010

Control file contains structure and status of the database. It contains database name, datafile and redo log information, SCN number, timestamp of database creation, redo log sequence number.

ramesh khanna

• Jun 27th, 2005

Information about the database,redologfile and datafile,archivelog file location and current scn no and redo log file

Answer Question  Select Best Answer

harshasp

 Profile Answers by harshasp Questions by harshasp

• Jul 16th, 2008

Index is an object in the oracle database used to speed up the performance of the queries ie. it improves the access speed and response of query will be good when the query makes use of Index.ThanksHarsha

ramesh khanna

• Jun 27th, 2005

Index is a object to fetch the data fast and where class in the sql can be used to use the index

Answer Question  Select Best Answer

venu

• Sep 1st, 2012

Code
 

will give the required result.

Wildy

• Jul 18th, 2011

Select instance_name, status, database_status, startup_time from v$instance;

Answer Question  Select Best Answer

wendyliu

• Oct 18th, 2006

Use nid utility.

Amit

• May 7th, 2005

You can change Database my by simple do some steps.  1. Alter Database backup control file to trace; 2. Above step will create a text control file. 3. Change the Database name ther...

Answer Question  Select Best Answer

Query v$log

chandrasekhar

• Sep 18th, 2011

I suppose the question is on designing and not just finding the size of present logfile.

Shrikant Pande

• Aug 24th, 2005

Select sum(bytes)/1024/1024 size_in_mb from v$log;

Answer Question  Select Best Answer

Whenever commit,checkpoint or redolog buffer is 1/3rd full

Jayesh Patel

• Oct 9th, 2007

LGWR writes:1) COMMIT/ ROLLBACK2) 1 MB of large transaction3) Before DBWR writes4) 1/3 of REDO LOG is full5) time out occurs6) Check Point encounters

SALIH

• Dec 15th, 2005

1.COMMIT or ROLLABCK2.time out occurs (3 secs)3 1/3 of log is full4. 1 mb of redo5. Checkpoint occurs

Answer Question  Select Best Answer

The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical standby is always an exact structural duplicate of the master database. The downside, though, is that logical standby is based on newer technologies (logical standby is new in Oracle 9.2) and tends...

Ashu Shukla

• Oct 29th, 2007

A physical or logical standby database is a database replica created from a backup of a primary database. A physical standby database is physically identical to the primary database on a block-fo...

santhosh

• Jun 26th, 2006

Physical Standby - acheived by copying the archivle log filesLogical Standby - makes the dml statements using archivelogs generated and applies to the secondary database

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

1. set SHARED_SERVERS=(more than 1) in init.ora2. make changes in tnsnames.ora file to get the connection with DISPATHERS rather than dedicated servers

SALIH

• Dec 15th, 2005

Use DBCA toolYou will get the option to select shared server mode.

Answer Question  Select Best Answer

paparao03@gmail.com

• Oct 31st, 2006

Query Rewrite option advantages we can get with the materialize view option also.

paparao03@gmail.com

• Oct 27th, 2006

I am agree with above(sheela) comments.along with It is more usedful OPTIONS LIKE FAST, COMPLETE, FORCE, WITH THE HELP OF MATERIALIZED VIEW LOG IS MORE USEFUL.

Answer Question  Select Best Answer

senthilora

 Profile Answers by senthilora Questions by senthilora

• Sep 24th, 2007

And.. It does not store any data value in it unlike normal index do.Queries will not get benefitted. This can be used only for analysis.

Varun

• Sep 11th, 2005

1. These are permanent and continue to exist unless we drop them.2. Their creation will not affect existing and new sessions. Only sessions marked for Virtual Index usage will become aware of their ex...

Answer Question  Select Best Answer

Sandesh

• Jun 6th, 2007

Change the domain name in the sqlnet.ora file in NAMES.DEFAULT_DOMAIN parameter.

Bhavani Shekhar

• Mar 15th, 2006

The Question is not clear about Where the Oracle database is residing.If the Oracle Database is resides on ur local machine then the domain name must be updated in the tnsnames.ora file. change this f...

Answer Question  Select Best Answer

sean21

 Profile Answers by sean21 Questions by sean21

• Mar 8th, 2010

Optimizer_mode = TYPICAL

Tirumal Devulapalli

• Feb 23rd, 2006

CBO (Cost Based Optimizer):Generates an execution plan for a SQL statementoptimizer_index_cost_adj parameter can be set to help CBO to decide an execution plan, which effects the speed of SQL query.we...

Answer Question  Select Best Answer

What is OERR Utility

Alpana G

 Profile Answers by Alpana G Questions by Alpana G

• Jun 20th, 2011

The OERR utility will display the complete error message text and the source of the error and recommended steps for resolving the problem.Syntax- oerr ora “error”oerr ora 0060000600, 00000...

Ramshankardba

 Profile Answers by Ramshankardba Questions by Ramshankardba

• Jan 17th, 2009

OERR Utility is an Oracle error lookup utility in UNIX environment.

Answer Question  Select Best Answer