[Oracle DBA ] - Performance Tuning

• Overview of SQL Plan Management

• Scripts to generate AWR report in Command line

• [ Oracle DBA  ] - Display Explain Plan with SET AUTOTRACE in SQL Plus

• [ Oracle DBA ] - Scripts to get SQL Performance Details

• Run SQL Tuning Advisor Manually for a SQL ID

• How to copy a specific Execution Plan for any SQL ID from One Server to Another Database

• Load SQL Plan from Cusrsor Cache to SQL Plan Baseline

• How to Disable a SQL Plan from the Baseline

• SQL Tracing Another Session with DBMS_MONITOR