Result Cache Vs Buffer Cache in Oracle 11g

[aman.oracle.dba]

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,

[aman.oracle.dba]

On Mar 1, 8:12 pm, "aman.oracle.dba" <aman.oracle....@gmail.com>
wrote:

Please allow me to elaborate more.
"The server result cache holds result sets and not data blocks"
So, it means it keeps exact data ?

[Michel Cadot]

"aman.oracle.dba" <aman.or...@gmail.com> a �crit dans le message de news:
348b70b4-cabd-404c...@f17g2000prh.googlegroups.com...

http://www.orafaq.com/forum/mv/msg/155194/443791/102589/#msg_443791

Regards
Michel

[Hemant K Chitale]

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
http://hemantoracledba.blogspot.com

On Mar 1, 11:12 pm, "aman.oracle.dba" <aman.oracle....@gmail.com>
wrote: