Architecture 9i

ORACLE 9i ARCHITECTURE QMnn Advanced Queueing ( Optional )

SMON

PMON

DIAG

Cleans User & Server Process

Instance Recovery Clean Temp Segments Collates Free Space

CJQn Coordinator Job Queue

DBSNMP

Real Application Clusters

( Optional )

( Optional )

( Optional )

( Optional )

D

( Optional )

Distributed Recovery

Java Pool

4K

UGA Response Queue

Keep Latches

Sort Extent Pool

I/O Buffer Area

Data Dictionary Cache

Enqueues

( Optional )

LRU List

Redo Log Buffer Large Pool

P

Hash Value SQL Source Execution Plan

Recycle

nK

MRPn Data Guard Managed Recovery

( Optional )

2K

F

DMON Data Guard Broker

RECO Checkpoint Queue

Database Buffer Cache Default

Snn Dnnn

LMD

Real Application Clusters

Shared SQL Area Library Cache

LMON

Real Application Clusters

System Global Area

Shared Pool

( Optional )

Shared Servers/ Dispatchers ( Optional )

LMSn

Real Application Clusters

Request Queue

8K

Free Memory

Other

Used Memory

Jnnn Job Queue Processes Replication and Queueing

Fixed Area

( Optional )

Free Memory

Pnnn

Intelligent Agent

Parallel Query ( Optional )

( Optional )

PGA

iNnn UGA

Stack Space

User Session Data

Cursor State

I/O Slaves Sort Area

( Optional )

DBWn

CKPT

LGWR

Dirty Buffer threshold Scan 1/2 LRU list Full Checkpoints Timeout 3 seconds

Shutdown,Log Switch log_checkpoint_timeout log_checkpoint_interval fast_start_io_target fast_start_mttr_target

1. Commits 2. Checkpoints 3. Redo Buffer 1/3 full

ARCn 1. Log Switch 2. alter ..... ( Optional )

Server Process

tnslsnr

Database

Dest_N Archived Logs Data

Files

Data Data

Data

Data

Online

Redo

Data

Archived Logs

Logs

Control Files

system01.dbf - Data Dictionary

User Process

Mark E. Fuller [email protected]

Duplexed Archived Logs

RMAN Network Files names.ora cman.ora snmp_r?.ora

Network Files tnsnames.ora listener.ora sqlnet.ora

Password File orapwSID

Server Parameter file spfileSID.ora

Parameter file(s) initSID.ora configSID.ora

Misc file(s) alert_SID.ora trace

Data Guard Broker Config

MML

Tape