Slide 6
Slide 6 text
6 Copyright © 2021 Oracle and/or its affiliates.
おさらい:Oracle Databaseの基本アーキテクチャ
三大構成要素
1. メモリ群
•System Global
Area(SGA)
•Buffer Cache, Shared Pool,
Large Pool, Log Buffer
and …
•Private Global Area(PGA)
2. プロセス群
•Background Process
•DBWn, LGWR, SMON, etc
•Foreground Process
3. ファイル群
•Database Files
•Control Files
•Online Redo Log Files
•etc
DB Server
SGA
Storage
Buffer Cache
PMON LGWR
SP SP SP
PGA
SMON Others
Log
Buffer
CR Block
Current
Block
Undo
Block
SP
DBWn
SP SP
Buffer
Cache Hit
Physical Reads Physical
Writes Redo Writes
Background
Process
Server Process (Foreground Process)
Oracle Client
(Application)
SQL実行
Data Files
Redo Log
Files