Background Processes

When the instance starts, Oracle creates a set of background processes that consolidate through functions what would otherwise have to be handled by multiple Oracle programs, each running for each user process called. These processes perform I/O and monitor the other Oracle processes. The background processes created include Database Writer (DBWn), Log Writer (LGWR), Checkpoint (CKPT), System Monitor (SMON), Process Monitor (PMON), Archiver (ARCn), Recoverer (RECO), Job Queue processes (Jnnn), Dispatcher (Dnnn), Lock Manager Server (LMS), and Queue Monitor (QMNn).

Database Writer (DBWn)

Database Writer (a mandatory background process) writes all modified blocks from the database buffer cache out to the proper datafiles. The ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.