Run Performance Tuning

oracle_dba_perf_toolkit/run_performance_tuning.sql

Disclaimer: This script is provided for educational and learning purposes. Review it carefully, test in a non-production environment, confirm privileges, and validate impact before using it in production.

PROMPT Running Performance Tuning Toolkit...
PROMPT Some scripts will prompt for days_back or sql_id.

@performance_tuning/01_top_sql_by_elapsed_time_awr.sql
@performance_tuning/02_top_sql_by_cpu_awr.sql
@performance_tuning/03_top_sql_by_io_wait_awr.sql
@performance_tuning/04_ash_wait_profile_last_60m.sql
@performance_tuning/05_sql_with_plan_changes_awr.sql
@performance_tuning/06_high_parse_sql_shared_pool_pressure.sql
@performance_tuning/07_segment_hotspots_reads_writes.sql
@performance_tuning/08_system_waits_non_idle.sql
@performance_tuning/09_io_latency_by_datafile.sql
@performance_tuning/10_pga_temp_spill_candidates.sql
@performance_tuning/11_top_sessions_by_cpu_now.sql
@performance_tuning/12_sql_plan_history_for_sql_id.sql
@performance_tuning/13_undo_pressure_by_hour_awr_cdb_root_only.sql
@performance_tuning/14_temp_spill_workarea_histogram.sql
@performance_tuning/15_undo_temp_parameter_review.sql
@performance_tuning/16_current_running_sql_realtime.sql
@performance_tuning/17_ash_current_and_recent_sql.sql
@performance_tuning/18_awr_sql_regression_compare_cdb_root_only.sql
@performance_tuning/19_ash_sql_timeline_for_sql_id_cdb_root_only.sql
@performance_tuning/20_snapshot_too_old_incidents_from_alert_log_cdb_root_only.sql
@performance_tuning/21_snapshot_too_old_undo_timeline_cdb_root_only.sql
@performance_tuning/22_snapshot_too_old_sql_candidates_from_ash_cdb_root_only.sql
@performance_tuning/23_current_long_transactions_holding_undo.sql
@performance_tuning/24_snapshot_too_old_risk_long_queries_vs_retention.sql
@performance_tuning/55_iops_average_max_by_instance_cdb_root_only.sql
@performance_tuning/56_sqlplus_cpu_iowait_iops_narrowdown_cdb_root_only.sql