Result Cache Vs Buffer Cache in Oracle 11g

From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: Mon, 1 Mar 2010 07:12:35 -0800 (PST)
Message-ID: <348b70b4-cabd-404c-b289-aaefa7d3d79e_at_f17g2000prh.googlegroups.com>



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, Received on Mon Mar 01 2010 - 09:12:35 CST

Original text of this message