Custom Reports – Oracle Repository
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.
 |
SQL statements ranked by disk I/O per second for a specified interval. |  | |
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. | | |
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 statements ranked by total number of executions. | | |
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 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? | | |
Provides execution, disk reads, buffer gets, row counts, sort and parse data for a specified SQL statement. | | |
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". | | |
Show the top SQL statements across all databases being monitored. | | |
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. | | |
gnite 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. | | |
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. Download | | |
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. | | |
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. | | |
Shows the Top SQL statements waiting on a specified file. | | |
Shows the Top Waits for a specified file. | | |
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. | | |
This report will prompt for a SQL statement and timeframes and give a list of P1 and P2 values and associated wait time. This report is most helpful for SQLs that wait on "buffer busy waits" or "read by other session" to understand if hot block problems exist. | | |
This report will list the top SQL statement across selected databases for a specified timeframe. A good report to see everything that happened on all database on one machine when a problem was occuring. | | |
This report will prompt for a specific Database Instance, Session Id and Begin/End dates. It uses the 'SQL_TEXT' function to return all of the queries for a particular session during a specific timeframe. This report is most helpful when looking at Idle Blocking sessions. The report will show all queries that the session executed before it became idle. | | |
Ignite provides drilldown into the top SQL statements for a specific machine, but it 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 Options > Advanced Options > CLEAN_DAYS_OF_DETAIL | | |
This report will list hourly averages for a specific Resource Metric for a specified date range. The reports prompts for Database Instance, Specific Metric and date range to report. | | |
| | |
This report will provide space used information by monitored database. | | |
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. | | |
Provides the Top N SQL statements run from the specified module for a given timeframe | |
|