Re: Result Cache Vs Buffer Cache in Oracle 11g
From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: Mon, 1 Mar 2010 07:22:11 -0800 (PST)
Message-ID: <e7cb8700-45d3-46d7-bec5-18bf881d269d_at_b36g2000pri.googlegroups.com>
On Mar 1, 8:12 pm, "aman.oracle.dba" <aman.oracle...._at_gmail.com> 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,
Date: Mon, 1 Mar 2010 07:22:11 -0800 (PST)
Message-ID: <e7cb8700-45d3-46d7-bec5-18bf881d269d_at_b36g2000pri.googlegroups.com>
On Mar 1, 8:12 pm, "aman.oracle.dba" <aman.oracle...._at_gmail.com> 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