Home » Other » General » Result Cache in Oracle 11g
Result Cache in Oracle 11g [message #461153] Wed, 16 June 2010 15:29 Go to next message
raghug
Messages: 2
Registered: June 2010
Location: Unites States
Junior Member
Can anyone help me out in understanding Result Cache mechanism in Oracle 11g .

It was said that the query results will be stored and whenever we run the same query again across session , the response will be faster.

But even in older versions alos we are achieving this . when we run query multiple times , result willbe stored in buffer and we will get faster response when we run the same query second time . Then what is the purpose of having Result Cache hint in Oracle 11 g .

Can anyone clarify my question ?

Appreciate your help.


Thanks .
Re: Result Cache in Oracle 11g [message #461156 is a reply to message #461153] Wed, 16 June 2010 17:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
In the previous versions, the data block is cached, not query result sets. The result sets should be reconstructed from the cache.
In 11g, the result sets are directly cached.
What happens if the underlying data is changed?
Now oracle is aware that the data is changed and will refresh its cache (after the first execution) automatically.

[Updated on: Wed, 16 June 2010 17:28]

Report message to a moderator

Re: Result Cache in Oracle 11g [message #461162 is a reply to message #461153] Wed, 16 June 2010 18:42 Go to previous messageGo to next message
wvu1999
Messages: 40
Registered: April 2007
Member

Here's an excellent article on the topic by Oracle Ace Guy Harrison.

http://www.toadworld.com/EXPERTS/GuyHarrisonsImprovingOraclePerformance/insideSpotlight/OptimizingtheOracle11gResultCache/tabid/606/D efault.aspx
Re: Result Cache in Oracle 11g [message #461190 is a reply to message #461153] Thu, 17 June 2010 00:49 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db112/search?remark=quick_search&word=result+cache
http://www.oracle.com/technology/oramag/oracle/07-sep/o57asktom.html

Regards
Michel
Previous Topic: New TNAMEs
Next Topic: Oracle 10g2R2 - Licensing in different versions
Goto Forum:
  


Current Time: Thu Mar 28 17:48:04 CDT 2024