23 декабря 2013
Опубликовано пн, 12/23/2013 - 17:07 пользователем talifa
1. SGA
1.1. Database Buffer Cache
1.1.1. Write List
1.1.2. Least Recent Used (LRU) List
1.1.2.1. Pinned buffers
1.1.2.2. Clean buffers
1.1.2.3. Free buffers или Unused
1.1.2.4. Dirty buffers
1.2. Redo Log Buffer
1.3. Shared Pool
1.3.1. Library Cache
1.3.1.1. Shared SQL Area
1.3.1.2. Private SQL Area (Shared Server Only)
1.3.2. Data Dictionary Cache
1.3.3. Server Result Cache
1.3.4. Other
1.3.5. Reserved Pool
1.4. Larger Pool
1.4.1. Response Queue
1.4.2. Request Queue
Опубликовано пн, 12/23/2013 - 17:03 пользователем talifa
Опубликовано пн, 12/23/2013 - 15:22 пользователем talifa
spfile
SGA allocated
background proccesses
control file is read
redo log files are opend
datafile headers are checked for consistency
instance recovery is started (if abort)