Topics | How To | Related Topics
Several reports are available for Oracle. The following table enumerates them, along with a short description. It also indicates whether an Analysis level Data Collection Job is required to produce complete and accurate data for each report.
For step-by-step instructions, see Run/Schedule a Report.
| Report Name | Description | Is Analysis level Data Collection Required? |
| ASM Disk Detail | In an ASM instance, this report displays details for every disk discovered by the instance, including disks which are not part of any disk group. In a database instance, this report only displays details for disks in disk groups that are in use by the database instance. Details include instance name, disk group name, number assigned to the disk within its disk group, total/unused disk capacity, disk name, date/time when the disk was added to the disk group and mounted by the instance, total number of bytes read/written, and total number of read/write errors. Use it to identify disks that are not part of a disk group, and to monitor read/write performance. | No |
| ASM Disk Groups | In an ASM instance, this report displays information about every disk group discovered by the instance. In a database instance, the report displays information about every ASM disk group mounted by the local ASM instance. Details include instance name, disk group name/number, sector/block/allocation unit sizes, and state/redundancy-type/capacity of the disk group. Use it to obtain general properties of ASM disk groups. | No |
| ASM Disks | In an ASM instance, this report displays properties of every disk discovered by the instance, including disks which are not part of any disk group. In a database instance, this report only displays properties of disks in disk groups that are in use by the database instance. Details include the instance name, disk group name/number, mount/header/mode status, disk state, and redundancy type. Use it to obtain general properties of ASM disks. | No |
| ASM Templates | Properties of every template that is present in every disk group mounted by the ASM instance. In a database instance, this report displays properties of every template that is present in every disk group mounted by the ASM instance with which the database instance communicates. Details include instance name, template name, disk group name, template entry number, redundancy type, stripe, and whether it is a system template. Use it to obtain general properties of ASM templates. | No |
| Databases | Information about the database from the control file, such as DBID, name, version, space used/reserved, utilization, creation date/time, log mode, control file type, open mode, and protection mode. Use it to obtain database details, and to monitor space utilization. You can set Thresholds to notify administrators to allocate more space for databases. | No |
| Datafiles | Information about datafiles including the database name, tablespace name, file name, file ID, relative file number, autoextensible indicator and increment, number of bytes/blocks/maximum bytes/user bytes, and availability indicator. Use it to obtain datafile details, and to monitor space utilization and availability. You can set Thresholds to notify administrators to allocate more space for critical datafiles. | No |
| Index Details | Detailed information about indexes including the database name, index name, uniqueness and compression indicators, B-tree level depth, last analyzed date/time, and indicators about whether the index is partitioned, on a temporary table, system generated, secondary object, and whether statistics were entered directly by the user. Use it to obtain the structural properties of indexes. | Yes |
| Index Statistics | Detailed statistical information about all indexes, including database name, index name, number of rows/leaf blocks/distinct keys, average leaf blocks and data blocks, cluster factor, and index level. Use it obtain block statistics of indexes. | Yes |
| Indexes | General information about indexes, such as database name, tablespace name, owner, index name, space used/free/reserved, index type, table owner/name, validity indicator, and number of rows. Use it to obtain general properties of indexes, and to monitor space utilization. You can set Thresholds to notify administrators to allocate more space for critical indexes. | Yes |
| Instance Recovery Needed | Summary of resources needed to recover the instance, including estimated I/Os for recovery, number of actual and target redo blocks, log file size redo blocks, target and estimated mean time to recover, optimal log file size, and estimated cluster available time. Use it to identify the resources needed to perform an instance recovery, and to monitor the mechanisms available to users to limit recovery I/O. | No |
| Instances | General information about Oracle instances, including instance name, database name, instance host name, version, startup time, archiver, log switch wait, instance status, and parallel indicator. Use it to obtain general properties of Oracle instances. | No |
| Largest Indexes | Index name, table name, owner (schema name), and total reserved space of indexes, ranked by size. Use it to identify large indexes and monitor their reserved space. | No |
| Largest Tables | Table name, owner (schema name), and total reserved space of tables, ranked by size. Use it to identify large tables and monitor their reserved space. | No |
| Largest Tablespaces | Tablespace name and total reserved space of tablespaces, ranked by size. Use it to identify large tablespaces and monitor their reserved space. | No |
| RMAN Backup Archived Redo Logs | Historical information from the recovery catalog about backup archived redo logs, such as instance name, RECID, stamp, thread, sequence, time stamp when Oracle first switched into the redo log, time stamp of the next redo log in the thread, number and size of blocks. Use it to obtain details about archived redo logs for recovery purposes. | No |
| RMAN Backup Corruption | Information about corrupt block ranges in datafile backups, including database name, file number, first corrupted block number, number of corrupted blocks, and the corruption type. Use it to identify corrupt blocks in datafile backups. | No |
| RMAN Backup Database Block Corruption | Information about database blocks that were corrupted after the last backup, such as the database name, RECID, stamp, file number, first corrupted block number, number of corrupted blocks, marked corrupt indicator, and the corruption type. Use it to identify corrupt blocks in database backups. | No |
| RMAN Backup Datafiles | Information about datafiles in backup sets from the control file, including database name, RECID, file number, creation time, resetlogs time, incremental level, checkpoint time, marked corrupt indicator, datafile blocks, completion time, and RMAN control file type. Use it to obtain properties of datafiles in backup sets. | No |
| RMAN Backup Files | Information about backups known to the RMAN repository as reflected in the recovery catalog, including instance name, primary key, backup type, file type, keep attributes, RMAN backup status, file name, and size. Use it to identify backup files in RMAN and obtain their properties. This report is only available for Oracle Database version 10g. | No |
| RMAN Backup Job History | Historical information about the finished and ongoing RMAN backup jobs. For ongoing jobs, this report displays progress and status. Details include the database name, SID, RECID, stamp, row type, RMAN operation, RMAN job history status, number of bytes processed, and start/end time. Use it to obtain the progress and status of RMAN backup jobs that are currently running, and to obtain details about completed RMAN backup jobs. This report is only available for Oracle Database version 10g. | No |
| RMAN Backup Redo Logs | Historical information from the recovery catalog about backup redo logs, such as instance name, RECID, stamp, name, sequence, time stamp when Oracle first switched into the redo log, time stamp of the next redo log in the thread, number and size of blocks, archived indicator, redo log status, standby database indicator, and whether this copy is located in the flash recovery area. Use it to identify backup redo logs in RMAN and obtain their properties. | No |
| Tables | Host name, database name, table name, used/free space, index space utilization, total reserved space, owner, tablespace name, num rows (specifies the number of rows in the table), blocks (specifies number of used blocks), empty blocks (specifies number of never used blocks), average space (specifies average available free space), chain count, and indicators for clustered, backed up (whether table has been backed up since last modification), partitioned, temporary, and skip corrupt. Use it to identify tables and monitor space utilization. You can set Thresholds to notify administrators to allocate more space for critical tables. | No |
| Tablespace Details | Information about individual tablespaces, including host name, tablespace name, database name, initial extent size, next extent (specifies incremental extent size), minextents (specifies minimum number of extents), maxextents (specifies maximum number of extents), percent increase, minimum extent (specifies minimum extent size for the tablespace), and allocation type. Use it to obtain properties of individual tablespaces and monitor increase in tablespace. | No |
| Tablespaces | Describes all tablespaces in the database. Details include database name, tablespace name, space reserved/used/free, utilization, block size, status, contents, local extents, ASSM, table compression, and big file indicator. Use it to obtain properties for all tablespaces, monitor space utilization, and to identify all tablespaces able to accommodate large datafiles. | No |
| Usage History by Database | Database usage by used and reserved space and utilization % over time. Use the optional Trending feature to predict future growth patterns for capacity planning. | No |
| Usage History by Index | Index usage by used and reserved space and utilization % over time. Use the optional Trending feature to predict future growth patterns for capacity planning. | No |
| Usage History By Instance | Instance usage by used and reserved space and utilization % over time. Use the optional Trending feature to predict future growth patterns for capacity planning. | No |
| Usage History by Table | Table usage by used and reserved space and utilization % over time. Use the optional Trending feature to predict future growth patterns for capacity planning. | No |
| Usage History by Tablespace | Tablespace usage by used and reserved space and utilization % over time. Use the optional Trending feature to predict future growth patterns for capacity planning. | No |
| Users | Describes all users of the database. Details include database name, tablespace name, user name, user ID, space used/reserved, utilization, account status, lock date, expiration date, temporary tablespace indicator, created date, and profile. Use it to obtain details about user accounts. | No |