Data Buffer Cache   «Prev 

Fewer buffers in Oracle

Output consisting fo 2 columns 1) Interval 2) Cache Misses

  1. As you can see, this database has some shared information, with nearly four million cache hits in the first 250 buffer blocks.
  2. From 250 on up, you can see a slowly decreasing downward trend, indicating that this application is doing some full-table scans or is not referencing a lot of common information.
Because buffer busy waits are due to contention between particular blocks, there is nothing you can do until you know which blocks are in conflict and why the conflicts are occurring. Tuning therefore involves identifying and eliminating the cause of the block contention.