Re: Result Cache Vs Buffer Cache in Oracle 11g
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 1 Mar 2010 17:26:53 +0100
Message-ID: <4b8beacf$0$21858$426a74cc_at_news.free.fr>
Date: Mon, 1 Mar 2010 17:26:53 +0100
Message-ID: <4b8beacf$0$21858$426a74cc_at_news.free.fr>
"aman.oracle.dba" <aman.oracle.dba_at_gmail.com> a écrit dans le message de news:
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,
http://www.orafaq.com/forum/mv/msg/155194/443791/102589/#msg_443791
Regards
Michel
Received on Mon Mar 01 2010 - 10:26:53 CST