Re: Page cache

Posted by satish on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Page-cache-tp7432p7458.html

Dear Erman,

Cache data in Oracle data buffer cache and again in file system buffer cache is wasting of memory by double caching.

Please correct us if our understanding is wrong

1)So,If the data required for a query is both in file system cache and in oracle database buffer cache,then in this case oracle always choose oracle data buffer cache

2)If data is not in Oracle data buffer cache but present in file system buffer cache,then oracle reads the data from file system buffer cache

3)Is OS cache and disk cache same?

Thanks,
satish