Home » RDBMS Server » Performance Tuning » result cache physical reads 0 on the first execution.What could be the reason (11g)
result cache physical reads 0 on the first execution.What could be the reason [message #607496] Fri, 07 February 2014 07:26 Go to next message
ashwanth77
Messages: 95
Registered: April 2013
Location: India
Member
Im trying to check the performance of the query using result_cache.When i execute the query for the first time without result cache hint i see that physical reads is 0.In most cases physical reads would be 0 oly during the subsequent executions.

./fa/11674/0/
Re: result cache physical reads 0 on the first execution.What could be the reason [message #607499 is a reply to message #607496] Fri, 07 February 2014 07:51 Go to previous message
John Watson
Messages: 4570
Registered: January 2010
Location: Global Village
Senior Member
If you want to force physical reads, flush the buffer cache before running the statement.
Previous Topic: Useful quotes to share with developers
Next Topic: package size
Goto Forum:
  


Current Time: Sun Sep 21 22:15:12 CDT 2014

Total time taken to generate the page: 0.11713 seconds