Oracle Database - Mining Active Session History (ASH) for Plan/SQL Execution Wait Events

Oracle Database - Mining Active Session History (ASH) for Plan/SQL Execution Wait Events

scripts Anonymous   May 29, 2017

In this blog I am going to discuss about mining ASH for wait events for a specific sql session or specific sql or specific plan hash value execution wait events....

Oracle Database - List of Indexes / Tables used in SQL Query / PL-SQL Procedure

Oracle Database - List of Indexes / Tables used in SQL Query / PL-SQL Procedure

scripts Anonymous   May 19, 2017

Recently I was tasked with taking out list of all the indexes which are used by long running queries inside PL/SQL code.  I had designed query in such a way...