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$>

"" <> a écrit dans le message de news:
| 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,

Michel Received on Mon Mar 01 2010 - 10:26:53 CST

Original text of this message