Re: Result Cache Vs Buffer Cache in Oracle 11g

From: Hemant K Chitale <>
Date: Tue, 2 Mar 2010 08:00:01 -0800 (PST)
Message-ID: <>

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
tables 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.
Not otherwise.

Hemant K Chitale

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

Original text of this message