Database Scripts

Please find scripts below to monitor or diagnose things in Oracle databases. Download them by clicking on the script’s name.

DB Version Script Purpose
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.