Home » Other » Training & Certification » Exam Question
Exam Question [message #221086] Fri, 23 February 2007 13:57 Go to next message
Seismo
Messages: 5
Registered: February 2007
Junior Member
This question stumps me and I haven't seen a good answer in the Oracle docs.

Your database is in archivelog mode.
What 4 processes are involved in a log switch?

o Archiver Process
o Database Writer
o Redo Log Writer
o SMON
o PMON
o CKPT

Obviously, checkpoint, archiver, and redo log writer.
What's the 4th, though? Database Writer flushes the buffer cache to disk but is it really involved in the log switch?
Do SMON and PMON do anything during a log switch?

[Updated on: Fri, 23 February 2007 19:33]

Report message to a moderator

Re: Exam Question [message #236322 is a reply to message #221086] Wed, 09 May 2007 10:44 Go to previous message
davidtxd
Messages: 3
Registered: May 2007
Junior Member
o Database Writer
Previous Topic: Associate Certification
Next Topic: oracle 9i forms
Goto Forum:
  


Current Time: Fri Mar 29 10:49:08 CDT 2024