OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » 11g tuning (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

11g tuning [message #438768]

Tue, 12 January 2010 02:59

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 ?

Report message to a moderator

Re: 11g tuning [message #438770 is a reply to message #438768]

Tue, 12 January 2010 03:08

Michel Cadot
Messages: 68650
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

Report message to a moderator