[embedplusvideo height=”328″ width=”584″ standard=”http://www.youtube.com/v/nNGLyWIPPTQ?fs=1″ vars=”ytid=nNGLyWIPPTQ&width=584&height=328&start=&stop=&rs=w&hd=0&autoplay=0&react=1&chapters=¬es=” id=”ep8443″ /]
Watch the earlier parts first:
- Writes from the SGA to the data files
- Does deffered writes
- like a hotel room clerk
- kicks blocks out to disk when new data needs free blocks
- writes info to the current group of redo logs
- very important process
- performs instance recovery
- cleans up after sorts
- Monitors Processes
- detects – deadlock detected for example
one big reason for checkpoints is that commonly accessed
data may never get written out to disk. A checkpoint forces
this to get written.
– is the SGA and background processes
Oracle database and the Oracle instance combined is called the Oracle Server.
You can have multiple instances associated with the same database, this is called RAC.
Dedicated server process connects through the PGA.