Monitor DB Transactional Blocking Locks in Oracle 9i

(Roger Eisentrager) This script will both alert and capture relavent data on Oracle SQL blocking locks events. The following script creates 2 procedures, and 1 new table (in place of TBS_AAAAA put in the tablespace you want in this table) and submits the proc to DBMS_JOB, running it at 10 minute

Read More - Register for Free Membership