摘要： Dump file C:\oracle\admin\ORCL\udump\ORA03560.TRCThu Mar 12 15:45:29 2009ORACLE V8.1.7.0.0 - Production vsnsta=0vsnsql=e vsnxtr=3Windows 2000 Version 5.1 Service Pack 2, CPU type 586Oracle8i Enterpris... 阅读全文

摘要： This script looks at X$KSQST, which contains a breakdown of enqueue gets and enqueue waits by lock type. Unfortunately, there is no indication of the relative duration of these waits, so care must be ... 阅读全文

摘要： Most blocking lock detection scripts fail to consider that processes waiting for, but not yet holding, a lock can block other processes that need a conflicting lock on the same resource. To resolve su... 阅读全文