Oracle Reports
The following reports are available from the Reports Manager (Tools | Reports | Reports Manager).
Cluster Reports| Report Name | Description |
|---|---|
| Clusters | Displays cluster information, including the cluster type, definitions, storage parameters, and affected tables. |
| Report Name | Description |
|---|---|
| Invalid objects | Displays any invalid objects for the selected schema and includes a subtotal of all invalid objects for that owner. |
| Loads into shared pool |
Displays packages that have been loaded five or more times, into the Oracle shared pool. Note: You must have DBA privileges for this report. |
| Non-system objects in SYSTEM tables |
Displays any objects in the SYSTEM tablespace that are not owned by SYSTEM. |
| Oracle initialization parameters | Displays the values for all parameters defined in the PFILE for the selected user. |
| Tablespaces near capacity | Displays tablespaces that over 90% full, and do not have the autoextend feature enabled. |
| Total shared pool reload stats |
Displays the number of times objects in the shared pool were reloaded. Note: You must have DBA privileges for this report. |
| User hit ratios | Displays the buffer cache hit ratio users and includes consistent gets, blocked gets, and physical reads. |
| User resource usage | Displays values for resource usage such as CPU used and SQL*Net roundtrips for each user. |
| Report Name | Description |
|---|---|
| Sequences | Displays the sequences that are within 10% of the maximum value. Any sequences that do not have a maximum value set, or those that cycle are excluded from the report. |
| Sequences near max | Displays the sequences that are within 10% of the maximum value. Any sequences that do not have a maximum value set, or those that cycle are excluded from the report. |
| Report Name | Description |
|---|---|
| Arguments of stand-alone stored programs | Displays any parameters required for the selected stored procedure. |
| Object type bodies | Displays the body or source code for a selected object. |
| Object types | Displays the type of objects owned by a user, including whether the objects are valid and when they were created or last modified. |
| Package bodies | Displays the body or source code for a selected package |
| Package specifications | Displays specifications for a selected package, including whether it is valid and when it was created or last modified. |
| Stand-alone stored programs | Displays the source code for a stored program, including the type of program and the last time DDL was generated. |
| Stored functions | Displays a list of stored functions for a selected owner. |
| Stored object with source | Displays a list of all stored programs including their source. |
| Stored procedures | Displays the source for stored procedures for a selected owner. |
| Report Name | Description |
|---|---|
| Synonyms | Displays information for each synonym, including the owner, table owner and name, and the DB link. |
| Report Name | Description |
|---|---|
| Indexes | Displays details for the index definition, storage parameters, and columns included in the index. |
| Non-indexed tables | Displays any tables that have not been indexed for the selected database. |
| Table comments | Displays any comments for the selected table. |
| Tables & columns | Displays all columns for a selected table, including the maximum transactions, used/free blocks, free lists and groups, min/max extents, and columns included in this index. |
| Tables & indexes | Displays any indexes for a selected table, including the status, uniqueness, and columns included in the index. |
| Report Name | Description |
|---|---|
| Triggers & columns | Displays triggers for a selected table, including the trigger event, status, WHEN clause, and columns associated with the trigger. |
| Report Name | Description |
|---|---|
| Sample | Displays a sample user report based on a select * from dual query. |
| Report Name | Description |
|---|---|
| View comments | Displays any comments for the selected view. |
| Views & columns | Displays all columns for a selected view, including the query and columns included in the view. |