• Database Health Check with Oracle ORAchk
• Using Oracle Trace File Analyzer (TFA)
• Using Database Security Assessment Tool (DBSAT)
• Using Real-Time SQL Monitoring Reports
• Oracle Data Dictionary Views
• Using Oracle Hang Manager
• Manage Automatic Diagnostic Repository Log and Trace Files
• Oracle ADRCI Commands
• Oracle SQL Tuning 10053 CBO Trace
• Oracle SQL Trace, trcsess and tkprof
• Using Oracle SQL Tuning Advisor
• Oracle SQL Access Advisor
• Using Oracle RAC Cluster Health Advisor(ochad)
• Oracle Explain Plan
• Using Oracle SQLTXPLAIN (SQLT)
• Oracle System State Dump
• Using Oracle OSWatcher Black Box
• Oracle SQL Health Check (SQLHC)
• Oracle ADDM, AWR, ASH Reports
• Using STATSPACK in Oracle 12c