Blitz Report™ Library
Module GL 143 AP 146 AR 123 FA 138 CE 25 PO 116 INV 130 OM 89 MFG 215 COST 175 PA 131 HR 182 PAY 152 SYS 162
149 reports
| Description | Download | ||
|---|---|---|---|
| AD ADOP Sessions | Online patching (adop) sessions of Oracle EBS 12.2 with one row per node and phase, showing the status, start and end time and duration of each phase.
Phases that do not apply to a session, for example all phases but apply in a hotpatch session, are not shown. The Patches column lists the patches applied in the session's apply phase. | System Enginatics, R12 only |   |
| AD Applied Patches | AD applied patches, patch runs, included bugs, filenames and actions | System Enginatics | |
| AD Applied Patches R12.2 | Check if a specific patch is applied in 12.2 | System Enginatics | |
| AD Code Levels | Code level and baseline of each Oracle EBS product and product family, as maintained by the patching utilities in AD_TRACKABLE_ENTITIES.
Patch readme files and My Oracle Support notes state prerequisites as code levels, for example R12.AD.C.Delta.15 for AD code level C.15. | System Enginatics, R12 only | |
| AD Patch Task Timing | Run time of each job of an adpatch, adop or upgrade session from AD_TASK_TIMING, to identify the jobs that took longest.
Session Percentage is the job's share of the total elapsed time of all jobs in the session. Jobs run in parallel by several workers, so the session's wall clock time is shorter than the sum of the job times. | System Enginatics | |
| ALR Alerts | System Enginatics | | |
| DBA AWR Active Session History | Active session history from the automatic workload repository | System Enginatics | |
| DBA AWR Blocking Session Summary | Summary of blocked and blocking sessions based on the active session history from the AWR.
The link to blocking sessions is deliberately nonunique without jointing to sample_id to increase the chance to fetch the blocking session's additional information such as module, action and client_id.
In some cases, such as row lock scenarios, the blocking session is idle and does not show up in the ASH.
We recommend doing further analysis with a pivot in Excel rather than by SQL, as Excel's drag- and drop is a lot faster than typing commands manually. | System Enginatics | |
| DBA AWR CPU Load (active session history) | Aggregates active sessions by snapshot time to identify times with high CPU load over a specific 'CPU Sessions From' threshold value. | System Enginatics | |
| DBA AWR CPU vs Wait Time Summary | Summary of database CPU vs. wait times and average active sessions for a specified time frame
To see data in this report based on dba_hist_sys_time_model, 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/ | System Enginatics | |
| DBA AWR Interconnect Traffic | Displays information about the usage of an interconnect device by instance in a RAC configuration.
ipq - Parallel query communications
dlm - Database lock management
cache - Global cache communications
All other values are internal to Oracle and are not expected to have high usage. | System Enginatics | |
| DBA AWR Latch Summary | Summary of latch statistics such as misses and wait times for a specified snapshot time interval | System Enginatics | |
| DBA AWR Latch by Time | Latch contention wait time history.
Each row shows the system-wide latch contention wait time per latch name of one AWR snapshot interval to identify high latch contention at specific times. | System Enginatics, R12 only | |
| DBA AWR PGA History | History of database PGA size and other statistics from v$pgastat in megabytes | System Enginatics | |
| DBA AWR SQL Execution Plan History | Execution plan history for a particular SQL id from the automatic workload repository | System Enginatics | |
| DBA AWR SQL Performance Summary | Database SQL performance summary from the Automatic Workload Repository (AWR) tables to give an overview of top SQL load and performance issues.
The report shows the summarized execution stats such as elapsed time and IO figures for a certain timeframe for individual SQL_ID and plan hash value combinations.
All IO figures are shown in MB.
Parameter 'Level' can be switched to aggregate data either by Module or by individual SQL and to show summarised figures or to split them by day.
The default sorting shows the most CPU intensive SQLs on top, as the tuning goal is usually server load… full description | System Enginatics | |
| DBA AWR Settings | Automatic workload repository settings such as retention period, snapshot interval and number of top SQLs to capture (from table underlying the view dba_hist_wr_control).
Note that for executing Blitz Report queries on AWR data, you require a Diagnostic pack license as explained in Oracle's note KB136730:
https://support.oracle.com/support/?kmContentId=1490798
topnsql=DEFAULT means the database captures the top 30 SQLs from 5 different categories (Elapsed Time, CPU Time, Parse Calls, Shareable Memory, Version Count) for each snapshot interval.
So the default setting would capture a maximum… full description | System Enginatics | |
| DBA AWR System Metrics Summary | Historic system statistics from the automated workload repository showing CPU load, wait time percentage, logical (buffer/RAM) and physical read and write IO figures, summarized in snapshot time intervals. All IO figures are measured in MB/s.
-CPU%: Total CPU usage percentage. If this is low, the hardware is underused and performance could potentially get improved by using it better e.g. by resolving IO bottlenecks (bigger RAM, faster storage) or parallelization of SQLs and user processes.
-WAIT%: Percentage of time that the DB process spends waiting rather than processing. If the wait% is… full description | System Enginatics | |
| DBA AWR System Time Percentages | Historic system time model values from the automated workload repository showing a breakdown of how much percent of the database time was spent e.g. on excuting SQL, PL/SQL or Java code, parsing statements etc..
To see data in this report based on dba_hist_sys_time_model, 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/ | System Enginatics | |
| DBA AWR System Time Summary | Historic system time model values from the automated workload repository showing how the database time was spent e.g. on excuting SQL, PL/SQL or Java code, parsing statements etc..
To see data in this report based on dba_hist_sys_time_model, 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/ | System Enginatics | |
| DBA AWR Tablespace Usage | Tablespace usage over time from the AWR | System Enginatics | |
| 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/ | System Enginatics | |
| 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/ | System Enginatics | |
| DBA AWR Wait Event Summary (active session history) | Wait event and CPU usage summary from the AWR active session history. | System Enginatics | |
| DBA Alert Log | V$DIAG_ALERT_EXT shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR) for the current container (PDB).
You could schedule it, for example, in incremental mode to send an email with errors that occured since the last scheduled report run. | System Enginatics | |
| DBA Archive / Redo Log Rate | If the database is running in ARCHIVELOG mode, the amount of generated archive log is shown.
For databases on NOARCHIVELOG, the approximate amount of generated redo is calculated by the number of log switches per hour and log file size. Note that this log rate is just an approximated maximum as switches could also occur without the log files being full.
Redo log files are located here:
select * from sys.v_$logfile | System Enginatics | |
| DBA Blocking Sessions | Chain of currently blocking and blocked database sessions from v$wait_chains | System Enginatics | |
| DBA CPU Benchmark2 | Benchmark report to measure a database server's CPU speed, mainly for PLSQL processing.
This report generates an output file of 200000 records from dual.
As the query itself should complete in less than a second, most of the execution time is spend in PLSQL code to generate the Blitz Report output file.
To measure meaningful results, there should be enough SGA memory assigned to ensure that the execution time is entirely spent on CPU and not IO related wait events (to be confirmed using the DBA SGA Active Session History report).
example performance for different CPU… full description | System Enginatics | |
| DBA CPU Benchmark3 | This Benchmark report measures a database server's CPU performance for arithmetic calculations by calculating about 40 million square roots.
example performance for different CPU types:
seconds rows/s CPU
7 285714 AMD Ryzen 9 5950X 16-Core Processor
13 153846
12 166667 AMD EPYC 7742 64-Core Processor
31 64516 Exadata CS X8M
42 47619 Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz
42 47619 Intel(R) Xeon(R) CPU E5-2699 v4 @ 2.20GHz
41 48780 Intel(R) Xeon(R) CPU E5-2699 v3 @ 2.30GHz
41 48780 Intel(R) Xeon(R) CPU E5-2670 v2 @ 2.50GHz
43 46512 Intel(R) Xeon(R) CPU E5-2686 v4 @ 2.30GHz… full description | System Enginatics | |
| DBA Data Files | Data and temp files per tablespace with their size, free space, autoextend settings and the space still available up to the maximum size.
All sizes are shown in MB.
Available Size and Max Used Percent take autoextend into account, so they show how close a file is to its real limit. Used and free space of temp files are shown by DBA Tablespace Usage.
In Backup Mode flags data files left in hot backup mode (alter tablespace ... begin backup).
Schedule the report with Max Used Percent From, for example 90, to get an email only when a data file is close to full. | System Enginatics | |
| DBA Database Links | Database links with their owner, remote user and connect string. | System Enginatics | |
| DBA Database Parameter Validation | Replicates the database initialization-parameter validation performed by Oracle's EBS Database Performance and Statistics Analyzer (My Oracle Support Doc 2126712.1 / KB627702), so DBAs no longer need to download, install and run that analyzer to check EBS parameter compliance.
Reference: https://support.oracle.com/rs?type=doc&id=2126712.1
It compares the current instance settings in v$system_parameter2 against Oracle's required values for the running RDBMS version (11.1 / 11.2 / 12.1 / 19c) and EBS release, per My Oracle Support Doc 396009.1 / KA1002 ("Database Initialization Parameters for… full description | System Enginatics | |
| DBA Dependencies (used by) | Hierarchical report showing all database objects using the specified object, e.g. a certain table and the report shows all the views or packages that are refrencing or depending on the specified table (bottom to top) | System Enginatics | |
| DBA Dependencies (uses) | Hierarchical report showing all dependent database objects that a specified object, e.g. a view or package name uses or depends on (top to bottom) | System Enginatics | |
| DBA Directories | Database directory objects with their operating system path and the users granted read, write or execute access to them. | System Enginatics | |
| DBA Editioned Object Summary | Summary of editioned objects per edition from ADZDSHOWOBJS.sql
There is a good blog: https://www.pythian.com/blog/technical-track/adop-edition-cleanup | System Enginatics | |
| DBA Editions | Database editions, their type and status | System Enginatics, R12 only | |
| DBA External Table Creation | System Enginatics | | |
| DBA Feature Usage Statistics | Database license feature usage statistics, such as the number of times that an AWR HTML report was run | System Enginatics | |
| DBA Hierarchical Profiler Data | Excel version of Oracle's hierarchical profiler dbms_hprof PLSQL performance analysis.
PL/SQL units that have been compiled in NATIVE mode cannot be profiled.
To gather information, you must ensure that the PL/SQL code is INTERPRETED."
Before compilation of the profiled code, execute:
alter session set plsql_code_type=interpreted; Create and setup access to profiler tables as sys:
exec dbms_hprof.create_tables(force_it=>true);
create public synonym dbmshp_trace_data for sys.dbmshp_trace_data;
create public synonym dbmshp_runs for sys.dbmshp_runs;
create public synonym dbmshp_function_info… full description | System Enginatics, R12 only | |
| DBA Index Columns | System Enginatics | | |
| DBA Jobs | System Enginatics | | |
| DBA Log Switches | System Enginatics | | |
| DBA ORDS Configuration Validation | Validates the Oracle REST Data Services (ORDS) configuration for Blitz Report webservices. Checks: ORDS schema enablement and URL mapping, REST module status, PL/SQL package validity, all 27 expected endpoint handlers and their ORDS template registrations, execute grants, URL-pattern privileges that intercept xxen_webservices calls and the OAuth client's role grants (catches HTTP 401 caused by pre-existing catch-all privileges), ORDS URL profile configuration with token endpoint validation, OAuth2 client_id/secret availability, and ORDS connection pool sessions. Use this report to diagnose… full description | System Enginatics, R12 only | |
| DBA Object Access Privileges | Database object privileges for a specific user, including privileges inherited through role grants. Useful for DB access security audits to understand exactly what objects a user can access and how the access was granted (directly or through which role chain). | System Enginatics, R12 only | |
| DBA Objects | All database objects | System Enginatics | |
| DBA Parameters | To validate recommended settings validate following notes:
Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1)
EBS Database Performance and Statistics Analyzer (Doc ID 2126712.1)
Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1) | System Enginatics | |
| DBA Profiler Data | Excel version of Oracle's dbms_profiler PLSQL performance analysis, see Oracle note:
Using DBMS_PROFILER (KB85737)
https://support.oracle.com/support/?kmContentId=97270
PL/SQL units that have been compiled in NATIVE mode cannot be profiled using the DBMS_PROFILER package.
To gather information using DBMS_PROFILER, you must ensure that the PL/SQL code is INTERPRETED."
Before compilation of the profiled code, execute:
alter session set plsql_code_type=interpreted;
To start and stop profiling code, use the following commands (see use… full description | System Enginatics, R12 only | |
| DBA Redo Log Files | System Enginatics | | |
| DBA Registry | Database components installed, such as Oracle Text, JServer or XML Database, with their version and status.
A component with a status other than VALID can cause errors in the Oracle EBS functionality that depends on it and is usually fixed by running utlrp.sql or the component's validation procedure. | System Enginatics | |
No reports match. Try fewer words or categories.
Also found in SQL, tables and columns
These reports don't mention the search in their name or description, but their SQL does.
Searching SQL…