Result Cache Vs Buffer Cache in Oracle 11g
Date: Mon, 1 Mar 2010 07:12:35 -0800 (PST)
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.
Thanks, Received on Mon Mar 01 2010 - 09:12:35 CST