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
841 reports
| Description | Download | ||
|---|---|---|---|
| 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 | |
| DBA Registry SQL Patch | DBA_REGISTRY_SQLPATCH contains information about the SQL patches that have been installed in the database.
A SQL patch is a patch that contains SQL scripts which need to be run after OPatch completes. DBA_REGISTRY_SQLPATCH is updated by the datapatch utility. Each row contains information about an installation attempt (apply or roll back) for a given patch. | System Enginatics, R12 only | |
| DBA Resource Limits | Current and highest utilization since instance startup of database resources such as processes, sessions and transactions, compared to their limits.
A Max Percent close to 100 shows that the instance reached the limit since startup. Reaching the processes or sessions limit causes ORA-00020 or ORA-00018 for new connections.
In a pluggable database, the database shows resource limits only in the container root. There the report shows the current number of processes and sessions against their parameter limits instead, without the highest utilization.
Schedule the report with Max Percent From,… full description | System Enginatics | |
| DBA Result Cache Objects and Dependencies | Shows result cache objects with the current number of cached results, the number of times these results were found and reused (scan count) and their dependency on objects causing the most frequent invalidations.
Warning !!!
Don't run this on a prod system during business hours as prior to DB version 12.2, selecting from v$result_cache_objects apparently blocks all result cache objects (see note 2143739.1, section 4.).
You may end up with all server sessions waiting on 'latch free' for 'Result Cache: RC Latch' while the report is running. | System Enginatics | |
| DBA Result Cache Statistics | Result cache statistics with size values in MB.
If the 'Maximum Size' is big enough, 'Create Count Failure' should be zero or low, same as 'Delete Count Valid', which depicts the number of valid cache results flushed out.
'Find Count' shows the number of cached results used (instead of executing the underlying sql/plsql) and should hence be as high as possible for maximum performance improvement.
A high number of 'Invalidation Count' or 'Delete Count Invalid' relative to 'Find Count' should get investigated further as it indicates a result_cache specified for code where the underlying data… full description | System Enginatics | |
| DBA SGA Active Session History | Active session history from the SGA.
Parameter 'Blocked Sessions only' allows a blocking scenario root cause analysis, e.g. by doing a pivot in Excel (see example in the online library).
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 then.
For scenarios where the blocking sessions are active and part of the ASH, Tanel Poder has a… full description | System Enginatics | |
| DBA SGA Blocking Session Summary | Summary of blocked and blocking sessions based on the active session history from the SGA.
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 SGA Buffer Cache Object Usage | SGA buffer cache space usage by object names (in MB).
'Object Percentage' shows how much of one particular object is currently stored in the buffer cache.
100% means that the object is completely in the buffer cache.
Current SGA memory usage is also listed in views:
select * from v$sga
select * from v$sgainfo
select * from v$sga_dynamic_components
Arup Nanda gives a good explanation on how the buffer cache works: http://arup.blogspot.ch/2014/11/cache-buffer-chains-demystified.html | System Enginatics | |
| DBA SGA 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 SGA Memory Allocation | Current SGA memory usage in gigabytes, showing the split between buffer cache and shared pool | System Enginatics | |
| DBA SGA SQL Execution Plan History | Execution plan history for a particular SQL id from the SGA | System Enginatics | |
| DBA SGA SQL Performance Summary | Database SQL performance summary from the SGA to give an overview of top SQL load and performance issues.
The purpose of this report, compared to 'DBA AWR SQL Performance Summary' is to retrieve SQLs which are not in the AWR, either becasue they ran after the most recent snapshot or because their performance impact is too small to be written to the AWR (see topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140).
This is useful for example to:
-Identify SQLs executed by a particular program or UI function without running a trace. Navigate to the UI functionality… full description | System Enginatics | |
| DBA SGA Target Advice | Orace's SGA target advice view.
It shows an estimation of how an SGA resize would affect overall database time and IO. | System Enginatics | |
| DBA SGA Wait Event Summary (active session history) | Wait event and CPU usage summary from the SGA active session history. | System Enginatics | |
| DBA SGA+PGA Memory Configuration | Current SGA and PGA memory configuration in gigabytes.
A frequent configuration problem is not making full use of the available hardware resources, especially the physical RAM of the database server.
This report shows the servers SGA, PGA and CPU configuration in comparison to the available hardware.
For maximum performance, configure the SGA+PGA to use the full available memory of your server minus a few gig for OS level caching, e.g. for writing and reading of PLSQL output files on the DB node and for process memory (an estimated 4MB per process, see below).
Oracle's performance tuning… full description | System Enginatics | |
| DBA SYSAUX Occupants | Space used in the SYSAUX tablespace by component.
All sizes are shown in MB.
The largest occupants are usually the AWR (SM/AWR) and the optimizer statistics history (SM/OPTSTAT). The SM/OPTSTAT row shows the statistics history retention in days and the oldest statistics still available. A lower retention, set with dbms_stats.alter_stats_history_retention, reduces the SYSAUX space used. | System Enginatics | |
| DBA Scheduler Jobs | System Enginatics | | |
| DBA Segments | Database segments such as tables, indexes, lob segments by size and total database size summary | System Enginatics | |
| DBA Session Longops | Estimated time to completion for long running sessions based on gv$session_longops | System Enginatics | |
| DBA Sessions | Current database sessions with their Oracle EBS user, responsibility, form or concurrent request, the SQL being executed, wait event, blocking session, and PGA, temp and undo usage. All sizes are shown in MB.
Status Duration is the time since the session last changed between active and inactive, so for an active session it is the run time of the current call. Temp Used and Undo Used are the space the session holds at the time of the report.
For a Blitz Report run inside a web service call, from the Excel add-in or a Blitz FSG drilldown, the user and responsibility are those of the run.… full description | System Enginatics | |
| DBA Table Columns | Report with all table column names based on dba_tab_columns, as finding tables by column names is a frequent task during SQL development | System Enginatics | |
| DBA Table Modifications | If table monitoring is activated, dba_tab_modifications shows the number of rows modified since the last time a table was analyzed. | System Enginatics | |
| DBA Tablespace Usage | Tablespace usage including currently active undo and temp tablepace usage in Megabytes | System Enginatics | |
| DBA Text Search | Full text search through database source code objects such as packages, procedures, functions, triggers etc.
The search can also be done using regular expressions.
To retrieve incorrect custom code such as a frequent performance issue calling the fnd_concurrent\.wait_for_request\s function with a zero interval time, for example, use parameter 'Multi Line Regex search' with the following value: fnd_concurrent\.wait_for_request\s*\(\s*request_id\s*=>\s*\w+\s*,\s*interval\s*=>\s*0\s*, | System Enginatics | |
| DBA Trace File Contents | V$DIAG_TRACE_FILE_CONTENTS contains trace data that is present in the trace files that are part of the current Automatic Diagnostic Repository (ADR).
Supported starting from Oracle Database 12.2. | System Enginatics, R12 only | |
| DBA Undo Statistics | Undo generation, longest running query and undo errors per 10-minute interval from gv$undostat, which keeps about four days of history.
All sizes are shown in MB, Undo Per Second in MB per second.
ORA-01555 snapshot too old occurs when a query needs undo that has already been overwritten. Compare the Longest Query Seconds with the Tuned Undo Retention Seconds: unexpired steal attempts and blocks show undo that was overwritten before its retention expired because the undo tablespace was too small. | System Enginatics | |
| DBA Users | Database user accounts with their status, lock and expiry dates, profile, tablespaces and quotas.
Default Password flags accounts that still have an Oracle-supplied default password (dba_users_with_defpwd). EBS Applications lists the Oracle EBS applications installed in the schema. | System Enginatics | |
| DIS Access Privileges | Discoverer access privileges | Enginatics | |
| DIS Business Areas | Summary report showing Discoverer business areas, with an access account showing how many times a business area's folder was used within the past x number of days. | Enginatics | |
| DIS Discoverer and Blitz Report Users | Shows the user adoption for companies replacing Discoverer with Blitz Report in a phased approach.
The report shows the number of Discoverer worksheets and Blitz Report executed every month per user, to help identifying the users still using Discoverer instead of Blitz Report. | Enginatics | |
| DIS End User Layers | Discoverer end user layers | Enginatics | |
| DIS Folders, Business Areas, Items and LOVs | Discoverer folders, business areas and items.
Columns 'Access Count' and 'Last Accessed' shows how many times a folder was accessed by a worksheet within the past x days.
Parameter 'Show Active Only' restricts to folders which have been accessed by worksheet executions within the past x days. | Enginatics | |
| DIS Import Performance | Query to review Discoverer to Blitz Report import performance, after running the 'Blitz Report Discoverer Import' concurrent program or mass migration script. https://www.enginatics.com/user-guide/#Discoverer_Worksheet | Enginatics | |
| DIS Items, Folders and Formulas | Discoverer items (expressions) and folders (objects), including join conditions and formulas (calculated items) | Enginatics | |
| DIS Users | Discoverer end user layer users of different types (application user, responsibility, database user) | Enginatics | |
| DIS Workbook Export Script | https://youtu.be/17_Au_11IBE
Use this report to migrate Discoverer workbooks to Blitz Report.
The migration process is described in the following link: https://www.enginatics.com/blog/discoverer-replacement-with-blitz-report/
1. Run this report 'DIS Workbook Export Script' to generate a list of commands to export xmls for all recently used Discoverer workbooks.
2. Create a new folder on a windows machine having the Discoverer Admin executable dis51adm.exe installed (contact Enginatics if you need help with the installation).
3. Open a Command Prompt window, cd to the new folder, and execute… full description | Enginatics | |
| DIS Workbook Import Validation | Discoverer workbook migration validation report showing every workbook and worksheet next to its conversion state: whether the workbook xml is uploaded, selected for conversion or converted, the object use key derived from the workbook xml, and the migrated Blitz report and template.
Workbooks known only from the end user layer and workbooks whose xml was uploaded after deletion from Discoverer are both listed, so gaps in either direction are visible. The Not yet imported parameter restricts to worksheets without a migrated template.
The Accessed after parameter restricts the output to… full description | Enginatics | |
| DIS Workbooks, Folders, Items and LOVs | Discoverer workbooks, their owners, folders, items and item class LOVs, derived from dependency table eul5_elem_xrefs. | Enginatics | |
| DIS Worksheet Execution History | Discoverer worksheet access statistics from table eul5_qpp_stats, including folder objects used.
Parameter 'Show Folder Details' switches between aggregate and list view of used folder objects. | Enginatics | |
| DIS Worksheet Execution Summary | Discoverer worksheet access statistic summary from table eul5_qpp_stats to show the number of active Discoverer users, number of different workbooks and worksheets executed and the number of different folder (combinations) that these are based on. | Enginatics | |
| DIS Worksheet SQLs | Discoverer worksheet SQL queries.
While the workbook documents are stored in a binary format in eul5_documents.doc_document and it's difficult extract their content (https://community.oracle.com/thread/2494216), there is an active trigger function
select ef.* from eul_us.eul5_functions ef where ef.fun_name='eul_trigger$post_save_document'
writing each worksheets' SQL query to table ams_discoverer_sql | Enginatics | |
| EAM Assets | Enterprise asset management asset details such as location, department etc. | Manufacturing Enginatics, R12 only | |
| EAM Weekly Schedule | Based on Oracle standard's EAM Weekly Schedule report
Application: Enterprise Asset Management
Source: EAM Weekly Schedule report (XML)
Short Name: EAMWSREP_XML
DB package: EAM_EAMWSREP_XMLP_PKG | Manufacturing Enginatics, R12 only | |
| EAM Work Orders | Enterprise asset management work orders including asset and cost information | Manufacturing Enginatics, R12 only | |
| EAM Work Requests | Maintenance work requests with their asset, priority, requester and the work order created for them, one row per work request.
Days Open and Overdue apply to requests that are neither rejected nor complete. Overdue means the expected resolution date has passed.
Work order status is the system status of the linked work order. | Manufacturing 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…