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