以下脚本可以用于诊断Oracle实例中的锁情况(Lock Status): 

REM SCRIPT: FULLY DECODED LOCKING

set echo off
set lines 200
set pagesize 66
break on Kill on sid on