List of reports

Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference

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/