How the SMON process is used to write into LOG files ?

Answers were Sorted based on User's Feedback



How the SMON process is used to write into LOG files ?..

Answer / guest

SMON process CAN'T be used to write into LOG files

Is This Answer Correct ?    7 Yes 6 No

How the SMON process is used to write into LOG files ?..

Answer / siva

In SGA Memory Struture,the SMON,PMON,Redo Log Buffer and
others.When the redo log buffer full then only with the help
of LGWR writed into the logfiles.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Database Management Interview Questions

What is an artificial (derived) primary key? When should it be used?

0 Answers  


What is the purpose of normalisation?

0 Answers  


Which of the packaged procedure is UNRESTRICTED ?

1 Answers  


How a Store Procedure called with a cursor out parameter.?

0 Answers   MCN Solutions,


Is access a database program?

0 Answers  






Which is better saving files in database or in file system?

0 Answers  


How to specify transaction or query timeout?

0 Answers  


Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.

0 Answers  


What is a trigger?

3 Answers  


I am using Oracle 10g and want to access the default tables of 9i? how? Any script and how to use it please mail me @ rashi.sandhu@gmail.com........

1 Answers  


WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.

4 Answers   CTS, iNautix, TCS,


How do you delete a table from database?

0 Answers  


Categories