Blitz Report™ Library

This library is a free open source SQL knowledge base for Oracle E-Business Suite customers and IT professionals. It contains SQLs that we created (category: Enginatics) and SQLs imported from Oracle’s BI Publisher reports (category: BI Publisher).

If you have Bitz Report installed, you can download a single or multiple reports as XML file from this library and automatically load them into your environment, including parameters, LOVs and category assignments.

If you would like to try one of these SQLs without having Blitz Report installed, as SQLs are composed dynamically at runtime, it is easiest to copy the query from the second tab of the example Excel sheet instead from the report’s detail page. Note that some of the reports require functions from utility package xxen_util.

To facilitate development work and help learning the EBS table structure, there are hyperlinks on each table to navigate directly to the corresponding Oracle ETRM record.

We also encourage you to contribute by adding your own SQL reports or suggesting enhancements and corrections to existing SQLs.
To add new reports, simply log in to our online demo environment, create a Blitz Report and it will automatically show up in this library (creation of a Blitz Report is shown here).

2 reports

DescriptionDownload
DBA AWR Wait Class by Time
Non idle session wait times by wait class over time. Each row shows the system-wide wait time per wait class of one AWR snapshot interval to identify unusual wait events that occured at specific times. Use the Session Type parameter to restrict either to foreground, background or all server processes. To see data in this report based on dba_hist_system_event, set the following: alter session set container=PDB1; alter system set awr_pdb_autoflush_enabled=true; https://www.enginatics.com/blog/updated-dba-awr-blitz-reports-now-work-with-plugglable-databases/
 Enginatics XLS XML
DBA AWR Wait Event Summary
Summary of wait times by wait event and event class for a specified snapshot time interval. Use the Session Type parameter to restrict either to foreground, background or all server processes. To see data in this report based on dba_hist_system_event, set the following: alter session set container=PDB1; alter system set awr_pdb_autoflush_enabled=true; https://www.enginatics.com/blog/updated-dba-awr-blitz-reports-now-work-with-plugglable-databases/
 Enginatics XLS XML