Re: Result Cache Vs Buffer Cache in Oracle 11g
Date: Tue, 2 Mar 2010 08:00:01 -0800 (PST)
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 3tables etc)
and so on.
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.
Hemant K Chitale
On Mar 1, 11:12 pm, "aman.oracle.dba" <aman.oracle...._at_gmail.com>
> Hi All,
> I am a bit puzzle between Result Cache and Buffer Cache.
Received on Tue Mar 02 2010 - 10:00:01 CST