Using STATSPACK in Oracle 12c
Oracle ADDM, AWR, ASH Reports
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 ASH Report Analysis
Oracle AWR Report Analysis
Oracle Wait Events and Solutions for Performance Tuning
Oracle Database In-Memory Advisor
Oracle 19c SQL Tuning Advisor
Oracle Real-Time ADDM Reports
Automatic Database Diagnostic Monitor (ADDM)
Oracle Instance Tuning Using Performance Views
Oracle AWR, Snapshots and Baselines