Back to Performance Tuning
sql
Run Deadlock Kit
oracle_dba_perf_toolkit/incident_kits/run_deadlock_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 Deadlock Troubleshooting Kit
PROMPT Recommended to run in CDB$ROOT.
@../performance_tuning/34_deadlock_incidents_from_alert_log_cdb_root_only.sql
@../performance_tuning/35_deadlock_lock_wait_chains.sql
@../performance_tuning/36_deadlock_locked_objects_and_sql.sql