Вы здесь

Activities calendar

23 декабря 2013

О, память сердца...

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

Процессы

этапы старта

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)