Database Tuning (MOSC)

MOSC Banner

Reducing the physical reads

edited Jul 5, 2011 5:28AM in Database Tuning (MOSC) 18 commentsAnswered
Hi All, I have a query which runs for  10 Minutes in the first execution and runs in less that 10 seconds in further executions. Could some body help me identifying the issue?

First Run

Statistics

----------------------------------------------------------

        205  recursive calls

          0  db block gets

     182998  consistent gets

      79000  physical reads

          0  redo size

          0  workarea executions - onepass

          0  workarea executions - multipass

          0  parse time cpu

          0  parse count (failures)

         19  execute count

          2  rows processed

 

Elapsed: 00:08:59:61

 Second Run

Statistics

----------------------------------------------------------

          0  recursive calls

          0  db block gets

     182942  consistent gets

         11  physical reads

          0  redo size

          0  workarea executions - onepass

          0  workarea executions - multipass

          0  parse time cpu

          0  parse count (failures)

          2  execute count

          2  rows processed

 

Elapsed: 00:00:07:21


Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center