Let's Join and share our day to day activities, Views, Knowledge, Questions and achievements in Oracle Database (8i / 9i / 10g or 11g)

Sep 24, 2010

Oracle Database architecture on Windows



An Oracle instance is shown as a Windows service (a background process registered with the operating system). The service is started by Windows and requires no user interaction to start. It contains the memory structures and threads needed to access the database.

The client connects via a shadow thread to the Oracle instance. The shadow thread connects directly with the process monitor. The memory structures include a shared pool of a library cache and a data dictionary cache, a database buffer cache, and a redo log buffer.

The threads include the database writer, log writer, process monitor, system monitor (all required while the database is available), checkpoint process, archive process, and distributed recovery process (all optional while the database is available).

There is an Oracle Database containing data files, control files, and redo log files. Associated with the database is the parameter file, password file, and archived log files.

Oracle Database ThreadDescriptionRequired/Optional
DBW0database writerRequired
LGWRlog writerRequired
PMONprocess monitorRequired
SMONsystem monitorRequired
CKPTcheckpoint process (thread on Windows) that runs by default on WindowsOptional
ARCH0archive process (or thread on Windows)Optional
RECOdistributed recovery background processOptional


Note:

You can view running background processes by issuing the following query:
SQL> select * from v$bgprocess where paddr <> '00';  


No comments:

Post a Comment