Oracle Database - Log Switches Per hour
This script is used to find out log switches per hour in Oracle Database ROWNUM < 31 tells to display data for last 30 days SET PAGESIZE 90SET LINESIZE 150set...
Monday, May 29, 2017
Oracle Database - Mining Active Session History (ASH) for Plan/SQL Execution Wait Events
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....
Friday, May 19, 2017
Oracle Database - List of Indexes / Tables used in SQL Query / PL-SQL Procedure
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...
Monday, April 24, 2017
Oracle Database - Historical Events / Wait Times / Statistics - AWR Data Mining & Extraction
In this blog I am going to discuss on how to mine and extract data from AWR Tables. In my previous blog I have discussed how to extract event /...
Wednesday, April 19, 2017
Oracle Database - Current Wait Events / Metrics Statistics
In this blog I am going to discuss on how to find out current statistics in the database. There are quite a few events and metrics available. I will be...
