Database Administration (MOSC)

MOSC Banner

querying session_longops

edited Mar 14, 2016 10:32AM in Database Administration (MOSC) 2 commentsAnswered

Hi

I am querying v$session_longops in 11.2.0.4 and getting this outpu

    2       1242       GVDW_OWNER Hash Join:  : 23150880 out of 22596840 Blocks done                13-mar-16 00:23:57 13-mar-16 00:57:50 102.45%                                   33.88 min passed                                    33.07 min expected total time

      1       1242       GVDW_OWNER Hash Join:  : 23150880 out of 22596840 Blocks done                13-mar-16 00:23:57 13-mar-16 00:57:50 102.45%                                   33.88 min passed                                    33.07 min expected total time

      2       1178       GVDW_OWNER Hash Join:  : 23100390 out of 22537305 Blocks done                13-mar-16 00:23:54 13-mar-16 00:57:50 102.5%                                    33.93 min passed                                    33.11 min expected total time

      1       1178       GVDW_OWNER Hash Join:  : 23100390 out of 22537305 Blocks done                13-mar-16 00:23:54 13-mar-16 00:57:50 102.5%                           

How do I interpret the fact that oracle read 23150880 out of 22596840 blocks in other word it read over 100% of the blocks? What does it mean?

thank you

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