INTERVIEW QUESTIONS ORACLE ORACLE ARCHITECTURE DETAILS

Question: What are the Back ground processes in Oracle?

Answer: There are a number of background processes running. Each process is used for a specific job.

* SMON – system monitor process is used to clean temporary segments and crash recovery of a crashed instance.
* PMON – process monitor is used to clean all resources acquired by a failed process.
* DBWR- Database writer is used to write “dirty block” to data files from the buffer.
* LGWR - Log writer is used to write the redo log buffer from system global area to online redo log file.
* MMAN – Memory manager process is used to manage the memory.
* ARCn - Archiver 0-9 is used for writing the online redo log files to the mentioned archive log destination after a log switch has occurred.
* CKPT – checkpoint process using the checkpoints information signals the synchronization of all database files. Used for database consistency and faster database recovery.
* LCK0 -9 – LOCK process is used to lock shared resources for manages the global enqueue requests and the cross-instance broadcast

There are a number of background processes running. Each process is used for a specific job.

* SMON – system monitor process is used to clean temporary segments and crash recovery of a crashed instance.
* PMON – process monitor is used to clean all resources acquired by a failed process.
* DBWR- Database writer is used to write “dirty block” to data files from the buffer.
* LGWR - Log writer is used to write the redo log buffer from system global area to online redo log file.
* MMAN – Memory manager process is used to manage the memory.
* ARCn - Archiver 0-9 is used for writing the online redo log files to the mentioned archive log destination after a log switch has occurred.
* CKPT – checkpoint process using the checkpoints information signals the synchronization of all database files. Used for database consistency and faster database recovery.
* LCK0 -9 – LOCK process is used to lock shared resources for manages the global enqueue requests and the cross-instance broadcast Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question