| Result Cache in Oracle 11g [message #461153] |
Wed, 16 June 2010 15:29  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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 |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
