Oracle Architecture Part 4

[embedplusvideo height=”328″ width=”584″ standard=”″ vars=”ytid=nNGLyWIPPTQ&width=584&height=328&start=&stop=&rs=w&hd=0&autoplay=0&react=1&chapters=&notes=” id=”ep8443″ /]

Watch the earlier parts first:

Part 1

Part 2

Part 3



Oracle Processes



Database Writer

  • 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



Log Writer

  • writes info to the current group of redo logs


System monitor

  • very important process
  • performs instance recovery
  • cleans up after sorts



Process monitor

  • Monitors Processes
  • detects – deadlock detected for example



Checkpoint process

one big reason for checkpoints is that commonly accessed
data may never get written out to disk. A checkpoint forces
this to get written.

Oracle Instance

– 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.

Leave a Comment