查看oracle被锁的表是谁锁的-创新互联
创新互联建站专注于云龙企业网站建设,响应式网站建设,成都商城网站开发。云龙网站建设公司,为云龙等地区提供建站服务。全流程按需求定制制作,专业设计,全程项目跟踪,创新互联建站专业和态度为您提供的服务>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
新闻标题:查看oracle被锁的表是谁锁的-创新互联
本文网址:http://hbruida.cn/article/dhsedh.html