Database Buffer Blocks

How many type of database buffer blocks are available? What are they?

Questions by jaganmohanrao

Showing Answers 1 - 2 of 2 Answers


  • Feb 17th, 2010

Following are the types of Buffer blocks available.

Pinned - Marked not to be released as per LRU algorithm. These are marked as required for further writes/changes/reads by transactions.
Dirty - Changed since recent fetch from Datafile(s).
Clean/Free - Have been marked as aged out. So, can be used for other fetches.
Unused - Never used as in case of fresh instance start.

Hope this is useful.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions