Home » RDBMS Server » Performance Tuning » 11g tuning (oracle 11g)
11g tuning [message #438768] Tue, 12 January 2010 02:59 Go to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
what is the advantage of a separate result cache when the querry results are normally stored in the buffer cache of sga by default for the subsequent querries ?
Re: 11g tuning [message #438770 is a reply to message #438768] Tue, 12 January 2010 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is stored in buffer cache are buffers (blocks) not result set so if the query is relaunched, Oracle has to reexecute it and possibly retrieves the blocks in the cache.
Result cache caches the result itself so if the query is relaunched, Oracle just has to fetch it from the result cache without reexecuting the query.

Regards
Michel
Re: 11g tuning [message #438771 is a reply to message #438770] Tue, 12 January 2010 03:11 Go to previous messageGo to next message
orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA
Member
Thanks, that means result cache will be faster for subsequent similar queries
Re: 11g tuning [message #438786 is a reply to message #438771] Tue, 12 January 2010 04:22 Go to previous message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, far faster, almost instantaneous.

Regards
Michel
Previous Topic: Query monitoring/intercepting
Next Topic: SQL Tuning and optimization- Help Needed
Goto Forum:
  


Current Time: Mon Sep 26 17:55:59 CDT 2016

Total time taken to generate the page: 0.10444 seconds