I would like a feature in Toad that does the following:
1) Collects database performance statistics and metrics for analysis and tuning.
2) Shows the exact time spent in the database, and even saves session information.
These tasks are done in Oracle using the "Automatic Workload Repository" AWR Active Repository. Is there a feature in Toad that utilizes the AWR Active Repository?
Toad has a feature that works with Oracle's "Automatic Database Diagnostic Monitor" (ADDM) Report Generator. Oracle's ADDM Report Generator allows you to compare snapshots/create reports and document non-problem areas in your database.