Explain what are Oracle Catalog and Oracle Archive log?

Sriniv@s..

• May 23rd, 2012

Oracle catalog contain the metadata of objects.
RMAN catalog maintain the backup information.
Redo data persistently stored in archive logs,for recovery..

pandish

 Profile Answers by pandish Questions by pandish

• Dec 31st, 2010

Catalog term is used in 2 ways.Catalog - All tables/views stores information about database and all objects in it.RMAN Catalog - Schema where RMAN executable stores/reads/writes the information about ...

Answer Question  Select Best Answer

How to estimate the size of a tablespace according to the size of the database size

chandubtech

 Profile Answers by chandubtech Questions by chandubtech

• Jun 30th, 2009

Select sum(bytes/1024/1024) mb from dba_data_files where tablespace_name='XXXXXX'

Answer Question  Select Best Answer

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