Trouble Shooting
- Health Checks
- Automatic Database Diagnostic Monitor (ADDM)
- Active Session History (ASH) Report
- Automatic Workload Repository (AWR)
- Database Troubleshooting
- Relational Data Issues, Fixing
- Listener Troubleshooting
- Network Troubleshooting
- Tracing for a Specific ORA-nnnn Error
- Remote Diagnostic Agent (RDA)
- Segment Advisor Recommendations
- Session Level Tracing
- SQL, Get for Running Process
- SQL Consuming Significant DB Time Event
- SQL Performance, Improving
- SQLPlus, Get Session Statistics
- SQL Tuning Advisor
For SQL performance you may want to consider creating a SQL Profile.
Under construction: Significant Database Time SQL Event