What are the Back ground processes in Oracle?

What are the Back ground processes in Oracle?

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.
Guidelines for estimating the space needed for a database
Estimating the space needed for a database is essential to figure out the performance of the application and size of database....
What are background processes in oracle?
What are background processes in oracle? - Oracle uses background process to increase performance....
What are various Oracle Operator?
Unary operators:- Operates on one operand. Binary:- Operates on two operands.
Post your comment