SQL Performance (MOSC)

MOSC Banner

timing in execution plan

edited Mar 30, 2016 5:04AM in SQL Performance (MOSC) 4 commentsAnswered

| Id  | Operation                          | Name                 | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |

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

|   0 | SELECT STATEMENT                   |                      |  5346K|   249M|       |  6096K  (1)| 00:01:03 |

|   1 |  HASH GROUP BY                     |                      |  5346K|   249M|   288M|  6096K  (1)| 00:01:03 |

Hi,

I find the timing in execution plan does not match in reality, AWRSQRPT also shows different time for per execution.

i) is the timing in HH:MM:SS?

ii) is the timing in awrsqrpt too  in same format HH:MM:SS?

iii) why awrsqrpt and dbms_xplan outputs different?.. which one is accurate and which one estimation?.. I found  none of them are matching timing with real-time monitoring

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