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