utllockt.sql
运行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博客 ” ，链接：https://blog.itpub.net/48010/viewspace-1015723/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
_undo_autotune
下一篇：
关于ora_pz进程的一些讨论
请登录后发表评论
登录
全部评论
