What is database buffer cache?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is database buffer cache?
Rating:
The database buffer cache is a portion of the System Global Area (SGA) , which is responsible for caching the frequently accessed blocks of a segment. The subsequent transactions requiring the same blocks can then access them from memory, instead of from the hard disk. The database buffer cache works on the basis of the least recently used (LRU) algorithm, according to which the most frequently accessed blocks are retained in memory while the less frequent ones are phased out.
Rating:
Was this information helpful?
Other articles
- What are stored outlines?
- What is the SQL Tuning Advisor?
- OCA 1z0-042 Short Notes: Exam passing tips
- What is the Segment Advisor?
- How to create an explain plan using the EXPLAIN PLAN FOR statement?