Process Architecture
Can be divided into 3 parts :
- DBWR : Writes modified blocks from buffers to disk
- LGWR : Writes accumulated redo log buffers to a log file. Write is triggered when buffer pool is 1/3rd full or at commit.
- PMON (Process Monitor) : Cleans up after process failures or disconnections. It releases the locks, rollbacks the changes made,etc. PMON connects to orphaned servers to do this. But mostly it is idle.