OraFAQ Forum: Performance Tuning » result cache physical reads 0 on the first execution.What could be the reason

Home » RDBMS Server » Performance Tuning » result cache physical reads 0 on the first execution.What could be the reason (11g)

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

result cache physical reads 0 on the first execution.What could be the reason [message #607496]

Fri, 07 February 2014 07:26

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.

/forum/fa/11674/0/