What are the different scenarios for rebuilding indexes...

chandubtech

 Profile Answers by chandubtech Questions by chandubtech

• Aug 2nd, 2008

Actually you need to rebuild the indexes for 2 main scenarios.1)deleted entries represents 20% or more of the current entries2)the index depth is more than 4 levelsOracle index nodes are not deleted p...

Answer Question  Select Best Answer

how to change the log_archive_format parameter in pfile if corresponding issys_modifiable parameter is "FALSE"
give me the full step by step procedure.


Thanks
Gyan

Srinivasa Reddy

• Aug 18th, 2011

As per Oracle document if the parameter value in ISSYS_MODIFIABLE column ( in v$parameter view ) is ... *IMMEDIATE - Parameter can be changed with ALTER SYSTEM regardless of the type of parameter fil...

Answer Question  Select Best Answer

How to collects the "current" redolog members(redo group) if these are physically deleted. There is no backup and NARCHIVELOG mode in database

Mohammed irfan Hussain

• Feb 8th, 2016

The moment you start the instance the smon gets started and collects redolog member data to datafiles. i,e crash recovery.

Answer Question  Select Best Answer

Mane

• Jul 8th, 2005

It can be, the only required option is that your tablespace have quota assigned to any user that want to store objects in it.

S.Velusamy Raja

• Jul 6th, 2005

Wish to know It can be or can not be. 

Answer Question  Select Best Answer

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh Questions by sivaraju.sateesh

• Apr 6th, 2009

Yes a view can be based on another view. For example data dictionary views can be used to create another view in order to improve better access.

soccer_champ

• Jun 18th, 2005

Yes, a view can be based on another view.

Answer Question  Select Best Answer

ashu_641981

 Profile Answers by ashu_641981 Questions by ashu_641981

• May 24th, 2011

Sequences are special database objects that provide numbers in sequence for input to a table.

soccer_champ

• Jun 18th, 2005

A sequence is a database object created by a user that can be used to generate unique integers. A typical usage of sequences is to generate primary key values which are unique for each row.  It i...

Answer Question  Select Best Answer

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh Questions by sivaraju.sateesh

• Apr 7th, 2009

Public synonym is a synonym which may not resodes in the owner schema.but it works as a same. to create public synonym we need special privileges

soccer_champ

• Jun 18th, 2005

A public synonym is owned by the special user group named PUBLIC and every user in a database can access it.  In case of doubt, contact me : bobby_1020@hotmail.com

Answer Question  Select Best Answer

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