Re: Result Cache Vs Buffer Cache in Oracle 11g

The Buffer Cache is for blocks. There is no direct tie-in with a specific query / queries.
The buffers representing N blocks of Table_A and M blocks of Table_B may be used by

a. Query Q_1 querying only Table_A
b. Query Q_2 query only Table_B
c. Query Q_3 querying Table_A + Table_B + Table_C (i.e joining 3

A Result Cache holds *data* (not Buffers, not Blocks) that is the result of a query.
If the same query is raised (even if it is part of another query), only then is the Result Cache used.
Not otherwise.

Hemant K Chitale
http://hemantoracledba.blogspot.com

On Mar 1, 11:12 pm, "aman.oracle.dba" <aman.oracle...._at_gmail.com> wrote:
> Hi All,
>
> I am a bit puzzle between Result Cache and Buffer Cache.
>
Received on Tue Mar 02 2010 - 10:00:01 CST