Node 1
Node x
Storage Subsystem
Storage Subsystem
Client
Listener
Data Guard Broker
- Manager
- CLI
RAC Guard
Failsafe
Server Management
- Server Control
OSD Clusterware
Application Server
Enterprise Manager
Directory Services
Heterogeneous Services
Advanced Replication
Advanced Queuing
Utilities
- Export / Import
- SQL*Loader
- Recovery Manager
Standby Database
Database Instance x
Instance 1
Instance
Standby Node
Parameter File
Password File
Parameter File
Alert.log
Trace Files
(Dump Destination)
External Tables
SGA PGA
DBWn
CKPT
SMON
RECO
PMON
DMON
(+ Config File)
DMON
(+ Config File)
QMNn
Agent
DMON
(+ Config File)
Agent
GSD
CM
LMON LMD0 LMSn LCK0
LMON LMD0 LMSn LCK0
GSD CM
Snnn
(Shared Server)
Dnnn
(Dispatcher)
Snnn Dnnn
CJQ0 Jnnn
LGWR
LNSV
(synch)
(asynch)
LGWn
ARCn
ARCn
(Background Processes)
(Background Processes)
(Plus Standard
Background Processes)
Large Pool
- Parallel exec. message
buffers
- RMAN backup/restore
- Shared Server UGA
(User Session Memory)
Java Pool
Cache
PGA
Private SQL
Session Memory
Stack Space
Response Queue Request Queue
Shared Pool
Library Cache
- Shared SQL
- PL/SQL
Dictionary
Cache
(Rowcache)
- DB Objects
- Users
- Privs
Control
Structures
Reserved Pool
Fixed SGA
Online Redo Logs (mirrored)
Thread x
Group 1 Group 2 Group 3
Thread 1
Group 1 Group 2 Group 3
Archive Logs (All Threads)
Buffer Cache
- Block buffers within
pools (default, keep,
recycle)
- Subcaches for each
block size (min. 1
granule)
(LRU Ageing) (LRU Ageing)
(static)
(dynamic*)
(dynamic*)
Block
Tablespaces
(System, Undo_Inst_1, Undo_Inst_x,
Temp, Tables, Indexes)
File 1
Segment 1
Extent 1
Block
Header
Header
Block Block
Extent n
Segment n
File n
Log
Buffer
Controlfiles
Copyright © 2002 Dr. Lars Ditzel Database Management — www.larsditzel.de
Oracle Server Architecture
(mirrored)
Persistent Area
- Bind Data
Runtime Area
- Work Areas
(Sort, Hash,
Bitmap Merge/
Create)
Standby
Controlfile
DB Files
Archive Logs
Standby Redo Logs
MRP0
(or foreground process)
ARC0
LSPn
RFS
FAL Client
FAL Server
DBWnCKPT
SMON
DIAG FMON EMN0
DIAG FMON EMN0
RSM0 NSV0
RSM0 NSV0
RECO PMON CJQ0 Jnnn
FAL Server
N-Tier
Client/Server
(Instance Registration)
(Workload Update)
Net Services
DB Application
- Forms
- Reports
- SQL*Plus
- Embedded SQL (C, Java, Cobol)
(Log Transport Services)
(Log Apply Services)
Managed Recovery
Dedicated Server
ORA<xxx>
("User" Process)
Dedicated Sever
ORA<xxx>
("User" Process)
(Instance Recovery)
(*granule unit size: 4MB if SGA < 128MB, 16MB otherwise)
(tunable)
