oracle architecture21

User Process

ORACLE ” 10g (Release 2) ARCHITECTURE

OPUS

Operating System

CPUs

PMON

-    Oeans User & Server Processes

-    Registers serwcewlth \ listener

MMAN *

Dynamicaliy ąuststhe sze of SGA components

MMON *

Captures aatistics for SQL objects wtiśch have been recenily modified

SMON

-Crash Recovery

-    Oean Temp Segmerrts

-    CoMates Free Space

RECO

The Distributed Transaction Recovery Process fmds pencfcng distributed transacSons

CJQn *

Job Oueue Processes Seiects jobs that need to be run..

Replication and Oueuing

V NOT PFRSISTENT .

G0f'⁽'^ed'

Shared Pool

Listener

^FJetwortrFfles^

-    listener.ora

-    tnsnames.ora

-    sqlnet.ora

Fork.

Server Process

jgram Global Area (PGA)

Library Cache User"s pnvileges

Shared SQL Area

-    Hash Value

-    SOL Source

-    Execution plan

sry Cache as Rom Ca che)

Latches

Default Pool

Database Buffer Cache

aged blocks (non recurring access)

Midpdnt In

Checkpoffit Oueue

■EH

Redo Log Buffer

Sort

Exterrt

Pod

DBSNMP*

Intelligent Agent

hot area    ZZZl    cołdarea

inseoion

0 i % a I    s

w blocks with recumna ▼

access in<Svjduał-bł<xks

read frpm disk go to the piiddte recyde / nK'

	[T]Z	[
	±4

Large Pool

		S
		IV

l/O Buffer Area

UGA

Response

Cfcieue

Reguest

Oueue

Fixed

Area

(Static

O/ertiea

d)

Stearns

Pool*

Pnnn *

Parallel Query

MRPn *

Data Guard Managed Recovery

f	UGA
Stack Space	User Session Data	Cursor State □

Oracle supports Bigfile Tablespaces and non-standard błock sizes

Automatic Storage Management *

-    RBAL

-    ARBn

-    ASN1B

Real Application Clusters *

-    LMON - ORACM

-    LCKn, - GSD

-    LMSn - DIAG

-    LMDn

w

Oracle background processes are persistent / processes that make up the instance and they will run until the instance is shutdown. They/' are processes, not programs. There is opfy one Oracle program on the host, i.e. thpfre is only one binary, named oracie. It is ju^t executed many times with differentnames

DBWn

Orty Buffer threshdd 'Scan 1/2 LRU hst FuH Checkpdnts ./ Timeout 3 seconds

CKPT

Regularly initiales a checkpoint UsesDBWR to wrrte aii dirty blocks Updates data file headers Shutdown

FJushes redo log buffer to online redo log file every 3 seconds. In commits. and checkpdnts orwhen the redo log buffer is 1MB a morę than 1/3 fuH. ^

ARCn *

Arcłwer process copies en onlme redo log file to another locafion when the redo log file is fiUed up or Ihere is a log switch

Dlctionary Data files

■ systemOI dbf

Advanced Oueuing *

-    QMNC

-    Qnnn

-    EMNn

Others *

-    RVWR, Flashback

-    CTWR, change tracking

process

Pass word File

orapwSID

Server Param eter file

spfileSiD.ora

Parameter

We

initSIO.ora

Logs

MultiJ Archive| \A	fexed I Redo Is

Rccv>vcry

caralog-

RMAN

Misc

fite<s)

atert_SlD.ora

tace

Data

Guard

Broker

Config

Oracle managed backups with RMAN

indicates optional setup

Cross-platform

transportable

tablespaces

^ Toanother Instance