Oracle EBS Database Administration Reports
73 ready-to-run SQL reports for Oracle E-Business Suite Database Administration, maintained by Enginatics and used in production at Oracle EBS customers worldwide. Each report page lists its parameters, the Oracle EBS tables it reads and an Excel example output. The most frequently used Database Administration tables in these reports are dba_hist_snapshot, dba_objects, v$parameter, dual, gv$sqlarea, obj$.
Run any of these reports in Excel in seconds: download Blitz Report™ free – your first 30 reports are free.
Database Administration SQL Reports
| Report | Description |
|---|---|
| DBA ASM Disk Groups | Automatic Storage Management disk groups used by the database, with their redundancy, total and free space. All sizes are shown in MB. Usable File Mb is the… |
| DBA AWR Active Session History | Active session history from the automatic workload repository |
| 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… |
| 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. |
| 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 dbahistsystimemodel, set the… |
| 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… |
| DBA AWR Latch Summary | Summary of latch statistics such as misses and wait times for a specified snapshot time interval |
| 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… |
| DBA AWR PGA History | History of database PGA size and other statistics from v$pgastat in megabytes |
| DBA AWR SQL Execution Plan History | Execution plan history for a particular SQL id from the automatic workload repository |
| 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… |
| 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 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… |
| 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… |
| 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… |
| DBA AWR Tablespace Usage | Tablespace usage over time from the AWR |
| 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… |
| 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… |
| DBA AWR Wait Event Summary (active session history) | Wait event and CPU usage summary from the AWR active session history. |
| DBA Alert Log | V$DIAGALERTEXT shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR) for the current container (PDB). You could schedule… |
| 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… |
| DBA Automated Maintenance Tasks | There are several automated jobs and ‘advisors’ running by default in an Oracle database that are often not required or should not run in Oracle EBS… |
| DBA Blocking Sessions | Chain of currently blocking and blocked database sessions from v$waitchains |
| DBA CPU Benchmark1 | Benchmark report to measure a database server’s CPU speed, mainly for PLSQL processing. This report generates an output file of 500000 out of a total of 561495… |
| 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… |
| DBA CPU Benchmark3 | This Benchmark report measures a database server’s CPU performance for arithmetic calculations by calculating about 40 million square roots. example… |
| 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… |
| DBA Database Links | Database links with their owner, remote user and connect string. |
| DBA Database Parameter Validation | Replicates the database initialization-parameter validation performed by Oracle’s EBS Database Performance and Statistics Analyzer (My Oracle Support Doc… |
| 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… |
| 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) |
| DBA Directories | Database directory objects with their operating system path and the users granted read, write or execute access to them. |
| 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 |
| DBA Editions | Database editions, their type and status |
| DBA External Table Creation | |
| DBA Feature Usage Statistics | Database license feature usage statistics, such as the number of times that an AWR HTML report was run |
| DBA Hierarchical Profiler Data | Excel version of Oracle’s hierarchical profiler dbmshprof PLSQL performance analysis. PL/SQL units that have been compiled in NATIVE mode cannot be profiled… |
| DBA Index Columns | |
| DBA Jobs | |
| DBA Log Switches | |
| 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… |
| 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… |
| DBA Objects | All database objects |
| DBA Parameters | To validate recommended settings validate following notes: Database Initialization Parameters for Oracle E-Business Suite Release 12 (Doc ID 396009.1) EBS… |
| DBA Profiler Data | Excel version of Oracle’s dbmsprofiler PLSQL performance analysis, see Oracle note: Using DBMSPROFILER (KB85737)… |
| DBA Redo Log Files | |
| 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… |
| DBA Registry SQL Patch | DBAREGISTRYSQLPATCH contains information about the SQL patches that have been installed in the database. A SQL patch is a patch that contains SQL scripts which… |
| 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… |
| 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… |
| 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… |
| 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… |
| 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… |
| 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%… |
| 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. |
| DBA SGA Memory Allocation | Current SGA memory usage in gigabytes, showing the split between buffer cache and shared pool |
| DBA SGA SQL Execution Plan History | Execution plan history for a particular SQL id from the SGA |
| 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… |
| 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. |
| DBA SGA Wait Event Summary (active session history) | Wait event and CPU usage summary from the SGA active session history. |
| 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… |
| 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… |
| DBA Scheduler Jobs | |
| DBA Segments | Database segments such as tables, indexes, lob segments by size and total database size summary |
| DBA Session Longops | Estimated time to completion for long running sessions based on gv$sessionlongops |
| DBA Sessions | Current database sessions with their Oracle EBS user, responsibility, form or concurrent request, the SQL being executed, wait event, blocking session, and… |
| DBA Table Columns | Report with all table column names based on dbatabcolumns, as finding tables by column names is a frequent task during SQL development |
| DBA Table Modifications | If table monitoring is activated, dbatabmodifications shows the number of rows modified since the last time a table was analyzed. |
| DBA Tablespace Usage | Tablespace usage including currently active undo and temp tablepace usage in Megabytes |
| 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… |
| DBA Trace File Contents | V$DIAGTRACEFILECONTENTS contains trace data that is present in the trace files that are part of the current Automatic Diagnostic Repository (ADR). Supported… |
| 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… |
| DBA Users | Database user accounts with their status, lock and expiry dates, profile, tablespaces and quotas. Default Password flags accounts that still have an… |
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH