utllockt.sql

最新推荐文章于 2025-08-15 10:38:51 发布

转载最新推荐文章于 2025-08-15 10:38:51 发布 · 157 阅读

文章标签：

#数据库

运行oracle自己的工具就可以查询锁的信息

You can also use the utllockt.sql script to display lock wait-for in a hierarchy. The script prints the sessions that are waiting for locks and the sessions that are blocking.

You must run the catblock.sql script (found in $ORACLE_HOME/rdbms/admin folder) as a sysdba user before using utllockt.sql. The catblock.sql script creates the dba_locksand dba_blockers views along with others that will be used by utllockt.sql[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/48010/viewspace-1015723/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/48010/viewspace-1015723/