Evergreen Database Technologies, Inc.
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) […]
Arthur C. Clarke wrote that any sufficiently advanced technology is indistinguishable from magic, and it sometimes makes troubleshooting seem like magic, or perhaps art. But it is neither magic nor art; it is process and this presentation uses a case study, such as resolving the ORA-03136 “connection lost” error, to demonstrate that process and to […]
Arthur C. Clarke wrote that any sufficiently advanced technology is indistinguishable from magic, and it sometimes makes troubleshooting seem like magic, or perhaps art. But it is neither magic nor art; it is process and this presentation uses a case study, such as resolving the ORA-03136 “connection lost” error, to demonstrate that process and to […]