|File Size||1.46 MB|
|Create Date||April 26, 2016|
|Last Updated||April 26, 2016|
This presentation was delivered at the Hotsos Symposium 2014 and at the Utah Oracle Users Group (UTOUG) Training Days 2014.
It describes a PL/SQL package that I put together called "ash_xplan.sql" which can be used to display real-time information about a SQL statement currently executing. This package combines information from the Active Session History (V$ACTIVE_SESSION_HISTORY) or "ASH" view with information from the DBMS_XPLAN package.
As of Oracle12c v12.1, nothing in Oracle displays elapsed time while the SQL statement is still executing, not even SQL Monitor.