Blog

When Dirty Blocks written to Disk ? - Oracle Architecture

  1. When a server process cannot find a clean, reusable buffer after scanning a threshold number of buffers, then the database writer process writes the dirty blocks to disk.
  2.  When the checkpoint takes place, the database writer process writes the dirty blocks to disk.

Follow me

Contact us for Training/ Job Support

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.