List of reports

Table 4-2 lists the reports defined in the monitoring template in alphabetical order.

Table 4-2 List of reports

Report nameDisplayed informationStorage location
Blocking Locks (5.0)Session that includes a lock that places another session in wait statusReports/RM Oracle/Troubleshooting/Real-Time/
Cache UsageBuffer cache usage ratio per minute over the past hourReports/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 agentsReports/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 agentsReports/RM Oracle/Monthly Trend/
Database Activity Status (5.0)Database activity statusReports/RM Oracle/Status Reporting/Real-Time/
Database Activity Status Detail (5.0)Details about database activity statusReports/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 agentsReports/RM Oracle/Status Reporting/Daily Trend/
Database Activity Trend (Multi-Agent)Overview of I/O processing per day over the past month for multiple agentsReports/RM Oracle/Monthly Trend/
Database Space Overview (5.0)Performance data and general database information on tablespaces and data filesReports/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 agentsReports/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 agentsReports/RM Oracle/Monthly Trend/Advanced/
Datafile I/O Activity Detail (5.0)Details about disk I/O operations on a data fileReports/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 hoursReports/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 hoursReports/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 hoursReports/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 monthReports/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 monthReports/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 monthReports/RM Oracle/Monthly Trend/Advanced/
Disk Sorts - Top 10 Sessions (5.0)Top 10 sessions in terms of the frequency of disk sort operationsReports/RM Oracle/Troubleshooting/Real-Time/
Full Table ScansPercentage of table lookups using no index per minute over the past hourReports/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 operationsReports/RM Oracle/Troubleshooting/Real-Time/
Lock Usage - Top 10 Sessions (5.0)Top 10 sessions in terms of the number of locks being heldReports/RM Oracle/Troubleshooting/Real-Time/
Locked Objects (5.0)Objects that are locked by transactionsReports/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 statusReports/RM Oracle/Troubleshooting/Real-Time/
Memory Usage - Top 10 Sessions (5.0)Top 10 sessions in terms of memory usageReports/RM Oracle/Troubleshooting/Real-Time/
Open CursorsCursor opened by a sessionReports/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 operationsReports/RM Oracle/Troubleshooting/Real-Time/
Redo Log Buffer ContentionNumber of times a process waited for space in the REDO log buffer per minute over the past hourReports/RM Oracle/Troubleshooting/Recent Past/
Server Configuration StatusInformation on setup parametersReports/RM Oracle/Status Reporting/Real-Time/
Session Detail (5.0)Detailed session informationReports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/
Session Statistics DetailStatistical information about a sessionReports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/
SGA Status (5.0)Status of each component in SGAReports/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 monthReports/RM Oracle/Monthly Trend/Advanced/
SQL TextPerformance data in the SQL Text and Explain Plan fieldsReports/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-timeReports/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 instanceReports/RM Oracle/Troubleshooting/Real-Time/
Tablespace StatusStatus of all tablespaces in the databaseReports/RM Oracle/Status Reporting/Real-Time/
Tablespace Status DetailDetails about a specified tablespaceReports/RM Oracle/Status Reporting/Real-Time/Drilldown Only/