SELECT b.session_id AS sid, NVL(b.oracle_username, '(oracle)') AS username, a.owner AS object_owner, a.object_name, Decode(b.locked_mode, 0, 'None', 1, 'Null (NULL)', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share (S)', 5, 'S/Row-X (SSX)', 6, 'Exclusive (X)', b.locked_mode) locked_mode, b.os_user_name FROM dba_objects a, v$locked_object b WHERE a.object_id = b.object_id ORDER BY 1, 2, 3, 4
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28916011/viewspace-2700632/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
查看oracle数据库真实大小
下一篇：
归档oracle alert日志
请登录后发表评论
登录
全部评论
