SQL Performance (MOSC)

MOSC Banner

same plan, different execution time, i/o

edited May 19, 2016 5:33AM in SQL Performance (MOSC) 6 commentsAnswered

Hi,

I am learning analyzing sqlt report, and here same plan hash value/plan used but query processed different number of rows..so time also very different.

Any way to check if data was different or not or anything else to check for diefferent timings?

List ordered by phv, source and instance.

#Plan Hash ValueSrcSourcePlan InfoPlan StabilityIs Bind SensitiveInst IDStatsTotal Elapsed Time in secsTotal CPU Time in secsTotal User I/O Wait Time in secsTotal Other Wait Time in secs1Total Buffer GetsTotal Disk ReadsTotal Direct Writes

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