When Dirty Blocks written to Disk ? – Oracle Architecture

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 21 Jun, 2021
  • 0 Comments
  • 15 Secs Read

When Dirty Blocks written to Disk ? – Oracle Architecture

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.