Database server = Instance + Datafile
Instance = SGA + Backround Process + PGA
SGA = Share Pool + Database Buffer Cache + Redo Log Buffer + Java Pool + Large Pool
Share Pool
Database Buffer Cache
Redo Log Buffer
Java Pool
Large Pool
Backround Process = PMON + SMON + DBWR + LGWR + CKPT + ORTHERS
PMON
SMON
DBWR
LGWR
CKPT
OTHER
PGA = User Process + Server Process
User Process
Server Process
Datafile = Parameter File + Password File + Data File + Control File + Redo Log File + Archived log File
Parameter File
Password File
Data File
Control File
Redo Log File
Redo Log File
转载于:https://blog.51cto.com/dajue/1323471