List of reports
Table 5-3 lists the reports defined in the monitoring template in alphabetical order.
Note that if the monitoring target is Oracle Database 12c Release 2 or later in a CDB configuration, some records or fields collect the following performance data:
-
Performance data for the PDBs and root container (CDB$ROOT) that are being monitored
-
Performance data for all PDBs and common performance data for database instances
For details, see 6. List of records for PFM - Agent for Oracle.
|
Report name |
Displayed information |
Storage location |
|---|---|---|
|
Session that includes a lock that places another session in wait status |
Reports/Oracle/Troubleshooting/Real-Time/ |
|
|
Buffer cache usage ratio per minute over the past hour |
Reports/Oracle/Troubleshooting/Recent Past/ |
|
|
Overview of the buffer cache usage ratio per hour over the past 24 hours for multiple agents |
Reports/Oracle/Status Reporting/Daily Trend/ |
|
|
Overview of the buffer cache usage ratio per day over the past month for multiple agents |
Reports/Oracle/Monthly Trend/ |
|
|
Information regarding the size of the unified audit file inside a PDB |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
CDB Data File Size Status(9.2) |
Information regarding the size of the data file used by a PDB |
Reports/Oracle/Status Reporting/Real-Time/ |
|
Information regarding the size of the diagnostic trace inside a PDB |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
Information regarding all PDBs inside the CDB |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
Status of tablespaces that are present in all PDBs inside the CDB |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
Database activity status |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
Details about database activity status |
Reports/Oracle/Status Reporting/Real-Time/Drilldown Only/ |
|
|
I/O statistical information on database instances per hour over the past 24 hours for multiple agents |
Reports/Oracle/Status Reporting/Daily Trend/ |
|
|
Overview of I/O processing per day over the past month for multiple agents |
Reports/Oracle/Monthly Trend/ |
|
|
Performance data and general database information on tablespaces and data files |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
Overview of free space at the instance level per hour over the past 24 hours for multiple agents |
Reports/Oracle/Status Reporting/Daily Trend/Advanced/ |
|
|
Overview of free space for instances per day over the past month for multiple agents |
Reports/Oracle/Monthly Trend/Advanced/ |
|
|
Details about disk I/O operations on a data file |
Reports/Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
|
|
Details about the average number of disk read operations on any data file per hour over the past 24 hours |
Reports/Oracle/Status Reporting/Daily Trend/Advanced/Drilldown Only/ |
|
|
Details about the average number of disk write operations on any data file per hour over the past 24 hours |
Reports/Oracle/Status Reporting/Daily Trend/Advanced/Drilldown Only/ |
|
|
Number of disk I/O operations for each data file per hour over the past 24 hours |
Reports/Oracle/Status Reporting/Daily Trend/Advanced/ |
|
|
Details about disk read operations on any data file per day for one month |
Reports/Oracle/Monthly Trend/Advanced/Drilldown Only/ |
|
|
Details about disk write operations on any data file per day for one month |
Reports/Oracle/Monthly Trend/Advanced/Drilldown Only/ |
|
|
Overview of disk I/O operations on data files per day over the past month |
Reports/Oracle/Monthly Trend/Advanced/ |
|
|
Top 10 sessions in terms of the frequency of disk sort operations |
Reports/Oracle/Troubleshooting/Real-Time/ |
|
|
All entries that have been recorded in the error log since the agent started |
Reports/Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
|
|
Status of the fast recovery area |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
Percentage of table lookups using no index per minute over the past hour |
Reports/Oracle/Troubleshooting/Recent Past/ |
|
|
Top 10 data files in terms of the number of disk I/O operations |
Reports/Oracle/Troubleshooting/Real-Time/ |
|
|
Top 10 sessions in terms of the number of locks being held |
Reports/Oracle/Troubleshooting/Real-Time/ |
|
|
Objects that are locked by transactions |
Reports/Oracle/Troubleshooting/Real-Time/ |
|
|
Top 10 sessions in terms of the length of a transaction that placed another session in wait status |
Reports/Oracle/Troubleshooting/Real-Time/ |
|
|
Top 10 sessions in terms of memory usage |
Reports/Oracle/Troubleshooting/Real-Time/ |
|
|
Cursor opened by a session |
Reports/Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
|
|
Top 10 sessions in terms of concentration of I/O operations |
Reports/Oracle/Troubleshooting/Real-Time/ |
|
|
Number of times a process waited for space in the REDO log buffer per minute over the past hour |
Reports/Oracle/Troubleshooting/Recent Past/ |
|
|
Information on setup parameters |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
Detailed session information |
Reports/Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
|
|
Statistical information about a session |
Reports/Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
|
|
Status of each component in SGA |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
Overview of the status of each component in SGA per day over the past month |
Reports/Oracle/Monthly Trend/Advanced/ |
|
|
Performance data in the SQL Text and Explain Plan fields |
Reports/Oracle/Troubleshooting/Real-Time/Drilldown Only/ |
|
|
(real-time report on the overall status of instance) |
Main performance data indicating the overall status of an instance in real-time |
Reports/Oracle/Status Reporting/Real-Time/ |
|
(real-time report on the general status of instance) |
Performance data indicating the general status of an instance |
Reports/Oracle/Troubleshooting/Real-Time/ |
|
Status of all tablespaces in the database |
Reports/Oracle/Status Reporting/Real-Time/ |
|
|
Details about a specified tablespace |
Reports/Oracle/Status Reporting/Real-Time/Drilldown Only/ |