Explain what are Oracle Catlog & Oracle Archive Log ?

jazz

• Sep 20th, 2011

When the log writer writes into the redo logs i.e online redo logs in circular motion.when one redo log is full it switches to another redo log , at this point of transfer it is called log switch.

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

oracle catalog used for recovery purpose in RMAN our target database registered in catalog and storing metadata for the target database. Archivelog is also used for recovery purpose but its store red...

Answer Question  Select Best Answer

Explain in detail what are bdump, cdump & udump?

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Jul 29th, 2011

background dump (bdump) :--. > bdump is used for all the issues raised related to background process in our database. its also contain alert .log which contain all activities and issues related to da...

Answer Question  Select Best Answer

What is dump destination?

What is Growth Factor?

What is PCT increase parameter in segment?

S. Lee

• Mar 9th, 2015

The percent increase in size of each subsequent extent that is added to your segment as it grows. Table test1 was created and is 4K in size. Initial size is set to 1K and pct increase set to 5. Once t...

Answer Question  Select Best Answer

What is PCT free and PCT used?

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 15th, 2018

-- PCTFREE , PCTUSED and High Level Watermark in datablock: ------------------------------------------------------------------------------ --> HLW is a term used with table segment in DB to show the...

Answer Question  Select Best Answer

What are Oracle Catlog & Oracle Archive Log?