List of reports
Table 4-2 lists the reports defined in the monitoring template in alphabetical order.
Table 4-2 List of reports
Report name | Displayed information | Storage location |
---|---|---|
Blocking Locks (5.0) | Session that includes a lock that places another session in wait status | Reports/RM Oracle/Troubleshooting/Real-Time/ |
Cache Usage | Buffer cache usage ratio per minute over the past hour | Reports/RM Oracle/Troubleshooting/Recent Past/ |
Cache Usage Status (Multi-Agent) | Overview of the buffer cache usage ratio per hour over the past 24 hours for multiple agents | Reports/RM Oracle/Status Reporting/Daily Trend/ |
Cache Usage Trend (Multi-Agent) | Overview of the buffer cache usage ratio per day over the past month for multiple agents | Reports/RM Oracle/Monthly Trend/ |
Database Activity Status (5.0) | Database activity status | Reports/RM Oracle/Status Reporting/Real-Time/ |
Database Activity Status Detail (5.0) | Details about database activity status | Reports/RM Oracle/Status Reporting/Real-Time/Drilldown Only/ |
Database Activity Status (Multi-Agent) | I/O statistical information on database instances per hour over the past 24 hours for multiple agents | Reports/RM Oracle/Status Reporting/Daily Trend/ |
Database Activity Trend (Multi-Agent) | Overview of I/O processing per day over the past month for multiple agents | Reports/RM Oracle/Monthly Trend/ |
Database Space Overview (5.0) | Performance data and general database information on tablespaces and data files | Reports/RM Oracle/Status Reporting/Real-Time/ |
Database Space Summary (Multi-Agent) (5.0) | Overview of free space at the instance level per hour over the past 24 hours for multiple agents | Reports/RM Oracle/Status Reporting/Daily Trend/Advanced/ |
Database Space Trend (Multi-Agent) (5.0) | Overview of free space for instances per day over the past month for multiple agents | Reports/RM Oracle/Monthly Trend/Advanced/ |
Datafile I/O Activity Detail (5.0) | Details about disk I/O operations on a data file | Reports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
Datafile I/O Status Detail (Reads) (5.0) | Details about the average number of disk read operations on any data file per hour over the past 24 hours | Reports/RM Oracle/Status Reporting/Daily Trend/Advanced/Drilldown Only/ |
Datafile I/O Status Detail (Writes) (5.0) | Details about the average number of disk write operations on any data file per hour over the past 24 hours | Reports/RM Oracle/Status Reporting/Daily Trend/Advanced/Drilldown Only/ |
Datafile I/O Status Summary (5.0) | Number of disk I/O operations for each data file per hour over the past 24 hours | Reports/RM Oracle/Status Reporting/Daily Trend/Advanced/ |
Datafile I/O Trend Detail (Reads) (5.0) | Details about disk read operations on any data file per day for one month | Reports/RM Oracle/Monthly Trend/Advanced/Drilldown Only/ |
Datafile I/O Trend Detail (Writes) (5.0) | Details about disk write operations on any data file per day for one month | Reports/RM Oracle/Monthly Trend/Advanced/Drilldown Only/ |
Datafile I/O Trend Summary (5.0) | Overview of disk I/O operations on data files per day over the past month | Reports/RM Oracle/Monthly Trend/Advanced/ |
Disk Sorts - Top 10 Sessions (5.0) | Top 10 sessions in terms of the frequency of disk sort operations | Reports/RM Oracle/Troubleshooting/Real-Time/ |
Full Table Scans | Percentage of table lookups using no index per minute over the past hour | Reports/RM Oracle/Troubleshooting/Recent Past/ |
I/O Activity - Top 10 Datafiles (5.0) | Top 10 data files in terms of the number of disk I/O operations | Reports/RM Oracle/Troubleshooting/Real-Time/ |
Lock Usage - Top 10 Sessions (5.0) | Top 10 sessions in terms of the number of locks being held | Reports/RM Oracle/Troubleshooting/Real-Time/ |
Locked Objects (5.0) | Objects that are locked by transactions | Reports/RM Oracle/Troubleshooting/Real-Time/ |
Longest Transactions - Top 10 Sessions (5.0) | Top 10 sessions in terms of the length of a transaction that placed another session in wait status | Reports/RM Oracle/Troubleshooting/Real-Time/ |
Memory Usage - Top 10 Sessions (5.0) | Top 10 sessions in terms of memory usage | Reports/RM Oracle/Troubleshooting/Real-Time/ |
Open Cursors | Cursor opened by a session | Reports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
Physical I/O - Top 10 Sessions (5.0) | Top 10 sessions in terms of concentration of I/O operations | Reports/RM Oracle/Troubleshooting/Real-Time/ |
Redo Log Buffer Contention | Number of times a process waited for space in the REDO log buffer per minute over the past hour | Reports/RM Oracle/Troubleshooting/Recent Past/ |
Server Configuration Status | Information on setup parameters | Reports/RM Oracle/Status Reporting/Real-Time/ |
Session Detail (5.0) | Detailed session information | Reports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
Session Statistics Detail | Statistical information about a session | Reports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
SGA Status (5.0) | Status of each component in SGA | Reports/RM Oracle/Status Reporting/Real-Time/ |
SGA Status Summary (5.0) | Overview of the status of each component in SGA per day over the past month | Reports/RM Oracle/Monthly Trend/Advanced/ |
SQL Text | Performance data in the SQL Text and Explain Plan fields | Reports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
System Overview (5.0) (real-time report on the overall status of instance) | Main performance data indicating the overall status of an instance in real-time | Reports/RM Oracle/Status Reporting/Real-Time/ |
System Overview (5.0) (real-time report on the general status of instance) | Performance data indicating the general status of an instance | Reports/RM Oracle/Troubleshooting/Real-Time/ |
Tablespace Status | Status of all tablespaces in the database | Reports/RM Oracle/Status Reporting/Real-Time/ |
Tablespace Status Detail | Details about a specified tablespace | Reports/RM Oracle/Status Reporting/Real-Time/Drilldown Only/ |