How the SMON process is used to write into LOG files ?
Answers were Sorted based on User's Feedback
Answer / guest
SMON process CAN'T be used to write into LOG files
Is This Answer Correct ? | 7 Yes | 6 No |
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 |
What is an artificial (derived) primary key? When should it be used?
What is the purpose of normalisation?
Which of the packaged procedure is UNRESTRICTED ?
How a Store Procedure called with a cursor out parameter.?
Is access a database program?
Which is better saving files in database or in file system?
How to specify transaction or query timeout?
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.
What is a trigger?
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........
WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
How do you delete a table from database?