Where does the process dumps information about the error?

ARUN BHUKKER

 Profile Answers by ARUN BHUKKER Questions by ARUN BHUKKER

• Oct 19th, 2012

Errors are stored in alert.log file it can be shecked using the parameter background_dump_dest

Use show parameter background_dump_dest
for path of the alert.log in trace directory

matabrez

 Profile Answers by matabrez Questions by matabrez

• Jan 10th, 2011

Alerts will log to alert.log  and alert trace files will be saved in  $ORACLE_HOME/admin/bdump directory.

Answer Question  Select Best Answer

When does the LGWR writes all redo-enteries to the redo-log buffer?

Suresh

• Oct 31st, 2017

1) When user hits commit
2) When there is 1/3rd full in redo log cache
3) One every 3 seconds

During this above situation LGWR writes redo log entries into redo log files from redo log cache !!

Mayur Pimpalkar

• Dec 24th, 2015

Lwgr process writes redo entries to online redolog files not to redobuffer.

Answer Question  Select Best Answer

Which parameter specifies the number of DBWn processes?

mosinpatel

• Jan 18th, 2018

SQL> show parameter db_writer_processes
NAME TYPE VALUE
------------------------------------ ----------- -------
db_writer_processes integer 1

srinivasarao

• Mar 22nd, 2015

DB_WRITER_PROCESS=""

Answer Question  Select Best Answer

What is log switch?

asit

• Jun 9th, 2012

log switch ::suppose we have two redo log files LOG A, LOG B. when transaction(DML) are occurred in Database then they are recorded in LOG A. When LOG A is filled up, a log switch occurs, All new tran...

Answer Question  Select Best Answer

How does the SMON process performs recovery after instance failure?

ranjithsv18

• Oct 2nd, 2013

When hardware failure, software failue and shutdown abnormally happen... SMON taking care of Instance failure, coalesce failure space and deallocating temp segment start to recover instance Roll fw...

Nagaraj OCP

• Dec 27th, 2011

When shutdown abort happens, oracle server gets crashed. To recover from the crash, SMON will check the online Redo data files and last SCN no in the Redo log files and SCN number in the undo tablespa...

Answer Question  Select Best Answer