querying session_longops
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