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.

/forum/fa/11674/0/

Report message to a moderator

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: 8803
Registered: January 2010
Location: Global Village
Senior Member
If you want to force physical reads, flush the buffer cache before running the statement.

Report message to a moderator

Previous Topic: Useful quotes to share with developers
Next Topic: package size
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Mar 21 10:24:07 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.