Presentation “Real-Time SQL Tuning” at Hotsos Sym2014 and UTOUG TD2014

April 26, 2016
| No Comments
[featured_image]
Download
Download is available until [expire_date]
  • Version
  • Download 324
  • File Size 1.46 MB
  • File Count 1
  • Create Date April 26, 2016
  • Last Updated April 26, 2016

Presentation "Real-Time SQL Tuning" at Hotsos Sym2014 and UTOUG TD2014

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.

The source code for the "ash_xplan.sql" script is on the Scripts page of this website, along with sample spooled output.

| Tags: , , , , ,