Custom Reports Library

Custom reports built to use the Ignite Performance Data Warehouse. These reports are developed by Confio DBAs to solve real customer performance problems. Execute the scripts via SQL*Plus or equivalent while logged into the Ignite schema in the repository database. Each script will prompt for all required information.

	Top SQL by Disk I/O per second SQL statements ranked by disk I/O per second for a specified interval.
	Top SQL for Program Ignite provides drilldown into the top SQL statements for a program, but can only span a day at most. This report will provide that data for a specified date range which can include many days. Since the report reads detailed data, it can only go back as far as the days specified in the File > Database Options screen.
	Transactions Per Second Provides the total number of SQL executions for a specified timeframe. This number combines all executions of SELECT, UPDATE, DELETE, INSERT and a few others and divides by the number of seconds in the given timeframe.
	Top SQL by Execution Count Top SQL statements ranked by total number of executions.
	Top New SQL Top SQL statements that have executed since the provided date, but not executed before. For example, which SQL statements are new since we applied that patch on June 1st.
	Top SQL for O/S User Ignite provides drilldown into the top SQL statements for an O/S User, but can only span a day at most. This report will provide that data for a specified date range which can include many days. Since the report reads detailed data, it can only go back as far as the days specified in the File > Database Options screen.
	Top SQL for Database User Ignite provides drilldown into the top SQL statements for a database user, but can only span a day at most. This report will provide that data for a specified date range which can include many days. Since the report reads detailed data, it can only go back as far as the days specified in the File > Database Options screen.
	Top SQL for a Timeslice Top SQL statements for a specified date range that executed between a specific timeslice. For example, what are my top SQL statements this week between 8:00 am and 5:00 pm?
	Top Objects for Specified Wait Oracle objects ranked by wait time for a specified wait event. For example, I have high wait times on "db file sequential read" and want to know what objects are being read.
	Query Statistics by Day Provides execution, disk reads, buffer gets, row counts, sort and parse data for a specified SQL statement.
	Top SQL Containing a String Gives a list of top SQL statements that contain the specified string. For example, I want to know all the SQL statements that contain the view named "ALL_CUSTOMERS".
	Concatenate SQL Text Function Ignite stores SQL text in chunks of 64 character lines just like v$sqltext does. In some reports you may want to concatenate that into one character string which is hard to do in SQL. This is function that can be used within a custom report to put the text together.
	Top SQLs for a File Shows the Top SQL statements waiting on a specified file.
	Top Waits for a File Shows the Top Waits for a specified file.
	Top SQL for All Monitored Databases Show the top SQL statements across all databases being monitored.
	Top SQL by Average Execution Shows the top SQLs ranked by average execution for a given time period. This report will not work for a time period of less than an hour.
	Top SQL for Execution Plan Ignite provides drilldown into the top SQL statements for a plan, but can only span a day at most. This report will provide that data for a specified date range which can include many days. Since the report reads detailed data, it can only go back as far as the days specified in the File > Database Options screen.

Confio Software

Ignite IT Performance

Custom Reports Library