同上
解决方案 »
- 有关不同用户备份的区别问题,很白很强大
- 一般我提问的帖子,见者有分。。
- ORACLE高级复制问题,急!
- The Network Adapter could not establish the connection
- 请beckhambobo(beckham) ,zmgowin(隐者),gslrq(夜归人)溺水三千等高手进,关于logminer 中的utl_file_dir参数 问题
- pro*c/c++ 中怎样调用带有结果集输出(游标引用输出参数)的存储过程?
- 刚新建的数据库不能登陆,提示错误ORA-12637:包接受失败
- 求救啊!!希望大家帮忙 谢谢
- Neo4j图数据库为什么可以重复插入同一条数据,怎么可以不重复插入
- OGG部署中遇到的问题,急!!万分感谢
- oracle如何查询表被锁定状态
- Windows平台批处理调用sqlplus问题
o.owner,o.object_name,o.object_type,s.sid,s.serial#
FROM v$locked_object l,dba_objects o,v$session s
WHERE l.object_id=o.object_id
AND l.session_id=s.sid
ORDER BY o.object_id,xidusn DESC
FROM V$LOCKED_OBJECT S
WHERE S.OBJECT_ID IN
(SELECT OBJECT_ID FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE');
SELECT /*+ rule */ lpad(' ',decode(l.xidusn ,0,3,0))||l.oracle_username User_name,
o.owner,o.object_name,o.object_type,s.sid,s.serial#
FROM v$locked_object l,dba_objects o,v$session s
WHERE l.object_id=o.object_id
AND l.session_id=s.sid
ORDER BY o.object_id,xidusn DESC
-----------------------------------------------------
SELECT *
FROM V$LOCKED_OBJECT S
WHERE S.OBJECT_ID IN
(SELECT OBJECT_ID FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE');