SQL Performance (MOSC)

MOSC Banner

sql awr numbers not matching

edited Dec 11, 2015 12:46AM in SQL Performance (MOSC) 4 commentsAnswered

Hi,

I am finding discrepancy between elapsed time value and timing in execution plan in .

values are mentioned below:-

Elapsed Time (ms)==> 9,398.95 ms (i.e., 9.3s)

but execution plan showing below:-

0 SELECT STATEMENT 97475 (100) 

1   SORT ORDER BY 377K 188M 226M 97475 (1) 00:19:30

2     TABLE ACCESS FULL F98865 377K 188M 55666 (1) 00:11:0

so, from execution plan, elapsed time should have been 19:30+11:00=30 minutes.

I believe both the values for samples execution over same time period, how can they be so different?

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