timing in execution plan
| 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