DEV Community

RK
RK

Posted on

What is buffer cache in oracle

  • The database buffer cache is the largest memory area in the SGA. This memory area stores the copies of the data blocks that are read from the database discs.

  • As this area is in the SGA, this data is available for all the users.

  • So when the first user runs a query, the related data is read from the disc and stored into the buffer cache.

https://link.medium.com/2w4tptBFPnb

Top comments (0)