Which three tasks are performed by background processes in an Oracle database instance?

Background processes manage core database operations. Let’s break it down:

A . Creating dedicated server connections.

False. Dedicated server connections are created by the listener, not background processes. The

listener hands off the connection to a server process (e.g., ora_s000), which isn’t a background

process.

B . Registering services with Oracle Net listeners.

True. The LREG process (Listener Registration, formerly PMON’s role) registers services with listeners,

using parameters like LOCAL_LISTENER.

Mechanics:LREG sends service details (e.g., orcl) to the listener every 60 seconds or on startup.

C . Writing redo to log files.

True. The LGWR (Log Writer) process writes redo entries from the redo log buffer to online redo log

files, ensuring transaction durability.

Mechanics:Triggered by commits, log buffer fills, or checkpoints.

D . Writing dirty database block images from the buffer cache.

True. The DBWn (Database Writer) processes write modified (dirty) blocks from the buffer cache to

data files, maintaining consistency.

Mechanics:Occurs at checkpoints or when free buffers are needed.

E. Reading database blocks into the buffer cache.

False. Server processes (foreground) read blocks into the buffer cache during user queries, not

background processes.

Reference:Oracle Database Concepts 23ai, "Background Processes."