Re: Result Cache Vs Buffer Cache in Oracle 11g

From: <>
Date: Mon, 1 Mar 2010 07:22:11 -0800 (PST)
Message-ID: <>

On Mar 1, 8:12 pm, "" <> wrote:
> Hi All,
> I am a bit puzzle between Result Cache and Buffer Cache.
> As per documentation, result cache keeps the data of query in it and
> it is part of shared pool. Now, Buffer cache keeps the result of all
> the queries and shared pool keep the query plans; so is it "Result
> Cache" keep the plan of any query or data also.
> Please suggest.
> Thanks,

Please allow me to elaborate more.
"The server result cache holds result sets and not data blocks" So, it means it keeps exact data ? Received on Mon Mar 01 2010 - 09:22:11 CST

Original text of this message