Installation
System Requirements
Install Toad
Specify App Data Directory Location
Install Toad Silently
Install Toad on Citrix Systems
Uninstall Toad
Configure Toad Layouts
Create Connections
Understand Toad Connections
Create Access Connections
Create Amazon Redshift Connections
Create BusinessObjects Connections
Configure DB2 Client Connections
Configure DB2 LDAP Support
Create DB2 Connections
Create Excel Connections
Create SharePoint Connections
Create Google Analytics Connections
Create Hive Connections
Create MySQL Connections
Create ODBC Connections
Configure Oracle LDAP Support
Create Oracle Connections
Create Oracle BI Connections
Create PostgreSQL ODBC Connections
Create Salesforce Connections
Create Snowflake Connections
Create SQL Server Connections
Create SSAS Connections
Create SAP Connections
Create SAP HANA Connection
Create Teradata Connections
Troubleshoot Connections
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. |