Back to Performance Tuning
sql
Run Response Time Kit
oracle_dba_perf_toolkit/incident_kits/run_response_time_kit.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 DB Response Time / DB Time / Wait Time Kit
PROMPT Recommended to run in CDB$ROOT for historical full picture.
@../performance_tuning/41_current_db_response_metrics.sql
@../performance_tuning/42_current_sql_response_speed.sql
@../performance_tuning/43_historical_db_time_wait_trend_cdb_root_only.sql
@../performance_tuning/44_historical_db_response_metrics_cdb_root_only.sql
@../performance_tuning/45_historical_sql_response_for_sql_id_cdb_root_only.sql
@../performance_tuning/46_current_vs_baseline_response_compare_cdb_root_only.sql