Term
Database Writer Process (DBW)
Required in 12c |
|
Definition
| Writes modified database blocks from the SGA's database buffer cache to the data files on disk. Required in 12c? |
|
|
Term
Checkpoint Process (CKPT)
Required in 12c |
|
Definition
| Updates the data file headers following a checkpoint event. Required in 12c? |
|
|
Term
Log Writer Process (LGWR)
Required in 12c |
|
Definition
| Writes transaction recovery information from the SGA's redo log buffer to the online redo log files on disk. Required in 12c? |
|
|
Term
Process Monitor Process (PMON)
Required in 12c |
|
Definition
| Cleans up failed user database connections. Required in 12c? |
|
|
Term
System Monitor Process (SMON)
Required in 12c |
|
Definition
| Performs instance recovery following an instance crash, coalesces free space in the database, and manages space used for sorting. Required in 12c? |
|
|
Term
Listener Registration Process (LREG)
Required in 12c |
|
Definition
| Registers information about the database instance and dispatcher proceses with the listener. Required in 12c? |
|
|
Term
Recoverer Process (RECO)
Required in 12c |
|
Definition
| Recovers failed transactions that are distributed acorss multiple databases when using Oracle's distributed database feature. Required in 12c? |
|
|
Term
Manageability Monitor Processes (MMON and MMNL)
Required in 12c |
|
Definition
| Gathers and analyzes statistics used by the Automatic Workload Repository (ASH). Required in 12c? |
|
|
Term
Virtual Keeper of Time (VKTM)
Required in 12c |
|
Definition
| Provides wall-clock time (updated every second) and reference-time counter. |
|
|
Term
Diagnosability (DIAG)
Required in 12c |
|
Definition
| Performs Diagnostic Dumps |
|
|
Term
Diagnosability (DIA0)
Required in 12c |
|
Definition
| Responsible for hang detection and deadlock resolution. |
|
|
Term
Archiver (ARCn)
Not mandatory in 12c |
|
Definition
| Copies the transaction recoery information from the redo log files to the archive location. You have up to 30 archival processes. |
|
|
Term
Recovery Writer (RVWR)
Not mandatory in 12c |
|
Definition
| Writes flashback data to flashback database logs in the fast recovery area. |
|
|
Term
ASM Disk (ASMB)
Not mandatory in 12c |
|
Definition
| Present on databases using ASM Storage Mgt disks. |
|
|
Term
ASM Balance (RBAL)
Not mandatory in 12c |
|
Definition
| Coordinates rebalance activity of disks in an ASM disk group. |
|
|
Term
Job Queue Monitor (CJQn)
Not mandatory in 12c |
|
Definition
| Assigns jobs to the job queue processes when using Oracle's job scheduling feature. |
|
|
Term
Job Queue (Jnnn)
Not mandatory in 12c |
|
Definition
| Executes database jobs that have been scheduled using Oracle's job-scheduling feature. |
|
|
Term
Queue Monitor (QMNn)
Not mandatory in 12c |
|
Definition
| Monitors the messages in the message queue when Oracle's Advanced Queueing feature is used. |
|
|
Term
Event Monitor (EMNC)
Not mandatory in 12c |
|
Definition
| Process responsible for event-management coordination and notification. |
|
|
Term
Flashback Data Archive (FBDA)
Not mandatory in 12c |
|
Definition
| Archives historical records from a table when the flashback data archive feature is used. |
|
|
Term
Parallel Query Slave (Qnnn)
Not mandatory in 12c |
|
Definition
| Carries out portions of a larger overall query when Oracle's parallel Query feature is used. |
|
|
Term
Dispatcher (Dnnn)
Not mandatory in 12c |
|
Definition
| Assign's user's database requests to a queue where they are then serviced by shared server processes when Oracle's Shared Server feature is used. |
|
|
Term
Shared Server (Snnn)
Not mandatory in 12c |
|
Definition
| Server processes that are shared among several users when Oracle's Shared Server feature is used. |
|
|
Term
Memory Manager (MMAN)
Not mandatory in 12c |
|
Definition
| Manages the size of each individual SGA component when Oracle's Automatic Shared Memory Management feature is used. |
|
|
Term
Change Tracking Writer (CTWR)
Not mandatory in 12c |
|
Definition
| Keeps track of which database block shave been changed when Oracle's incremental Recovery Manager feature is used. |
|
|
Term
Space Management Coordinator (SMCO)
Not mandatory in 12c |
|
Definition
| Coordinates various space management tasks. |
|
|
Term
|
Definition
| Worker processes for Space Management Coordinator. |
|
|
