Background Process | Description and Function |
Database
Writer (DBWR) |
This background process is
mandatory. Its function is to transfer modified blocks from
the database buffer cache to the datafiles. The DBWR writes to the datafiles when one of the following events occur in the database: Normal or incremental checkpoint The number of dirty buffers reaches a pre-defined threshold value The server process scans a pre-defined number of blocks looking for free space needed by new blocks being read in. Timeout occurs Tablespace is taken offline in normal or immediate mode. Tablespace is made read-only Dropping or truncating a table Online backup is done on a tablespace using ALTER TABLESPACE... BEGIN BACKUP command. |
Log Writer (LGWR) | This background process is
mandatory. It transfers redo entries that have been written
to the redo log buffer to the online redo log files present
on disk. The LGWR writes to the online redo log files when one of the following events occur in the database: A commit is issued. The Redo Log Buffer is one-third full. More than 1MB of changes (updations) has been made in the database. Every three seconds Just before the DBWR writes from the database buffer cache to the datafiles. |
Checkpoint (CKPT) | This background process is
mandatory. When the contents of the database buffer cache are transferred to the datafiles by the DBWR background process, the event is referred to as a CHECKPOINT. When a checkpoint occurs the Checkpoint (CKPT) background process updates the headers of the datafiles and control files to indicate the most recent checkpoint. This process is therefore responsible for synchronizing the database. |
System Monitor (SMON) |
This background process is
mandatory. It is responsible for performing recovery in the
event of an instance failure. Instance failure occurs during an abnormal shutdown of the database, such as if a shutdown is performed using the ABORT option. During instance recovery the SMON process performs a roll forward operation. During this step all committed transactions that were not written out to the datafiles at the time of failure were be completed. This step maybe followed by a rollback during which time either the SMON or individual user processes undo all the changes that were uncommitted during the time of failure. Certain additional functions performed by the System Monitor involve coalescing of free space in dictionary-managed datafiles and releasing temporary segments that are created in the datafiles. |
Process Monitor (PMON) |
This background process is
mandatory. Users connect to the database to access data. When a user connects to the database, a process known as a User process is started on behalf of the user on the client machine. If the user terminates his/her session abnormally, resources that were being used by the user session continue to remain attached until the PMON background process cleans it up. The PMON background process is responsible for cleaning the resources such locks on tables being held by failure user processes. The process also restarts dead dispatcher processes. |
Archiver (ARCH) |
This is an optional
background process. It can be started when you wish to
operate the database in an archivelog mode. This mode of database operation allows for complete recovery of the database in an event of a failure. The ARCH background process transfers the contents of the online redo log files to archival media which could be disk or tape |
The other optional processes
in Oracle 10g are the : |
CJQ0 Coordinator Job Queue
background process Dnnn Dispatcher process Pnnn Parallel Query Slaves QMNn Advanced Queuing RECO Recoverer Snnn Shared Server Processes MMON Memory Monitor MMAN and MMNL. |
Initialization Parameter | Description |
Compatible | Refers to the version of the
server with which the instance should be compatible. |
Processes |
The maximum number of
operating system processes that can connect simultaneously
to the instance. |
Sessions |
|
Pga_aggregate_target |
|
Nls_language |
|
Nls_territory |
|
Db_domain |
|
Shared_servers |
|
Instance_number |
|
Cluster_database |
|
Db_block_size |
|
Sga_Target |
|
Control_files |
|
Db_name |
|
Db_recovery_file_dest |
|
Remote_listener |
|
Db_recovery_file_dest_size |
|
Db_create_online_log_dest_n |
|
Db_create_File_dest |
|
Log_archive_Dest_n |
|
Log_archive_dest_state_n |
|
Remote_login_passwordfile |
|
Db_unique_name |