Technical Discussion :: DBMS
Home > Technical Interview Q&A > DBMS > Discussion
8 / 143
What is data buffer cache?
Answer:
Database buffer cache is typically the largest portion of the SGA. It has data that comes from the files on disk. Because accessing data from disk is slower than from memory, the database buffer cache's sole purpose is to cache the data in memory for quicker access.
Asked In ::
Rahul Kumar
23 Feb, 2019 5:07 AM
Database buffer cache is typically the largest portion of the SGA. It has data that comes from the files on disk. Because accessing data from disk is slower than from memory, the database buffer cache's sole purpose is to cache the data in memory for quicker access.