Oracle Reports
The following reports are available from the Reports Manager (Tools | Reports | Reports Manager).
Show all
| Clusters |
Displays cluster information, including the cluster type, definitions, storage parameters, and affected tables. |
| 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. |
| 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. |
| 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. |
| Synonyms |
Displays information for each synonym, including the owner, table owner and name, and the DB link. |
| 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. |
| Triggers & columns |
Displays triggers for a selected table, including the trigger event, status, WHEN clause, and columns associated with the trigger. |
| Sample |
Displays a sample user report based on a select * from dual query. |
| 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. |
Related Topics
About Managing Reports
Tutorial: Create a Toad Data Report
About Designing Toad Data Reports
Cluster Reports