Please find scripts below to monitor or diagnose things in Oracle databases. Download them by clicking on the script’s name.
|12.1, 12.2||check_patches.sql||Monitor applied PSUs and BPs from DBA_REGISTRY_SQLPATCH and REGISTRY$HISTORY|
|11.2, 12.1, 12.2||capture_awr.sql||Capture statements from AWR – uses the oldest and newest available snapshot by default and limits to 5000 statements by elapsed time.|
|11.2, 12.1, 12.2||capture_cc.sql||Capture statements from Cursor Cache – uses a conservative test setting for 30 seconds only polling the CC every 5 seconds – needs to be adjusted for live systems.|