select * from v$locked_object;
select * from dba_objects where object_id=12642;
-------------------------------------------------------------
select s.sid,s.SERIAL#,s.*,l.*,o.* from v$session s,v$locked_object l,dba_objects o where s.sid=l.session_id and l.OBJECT_ID=o.OBJECT_ID;
alter system kill session '932,1832';-----sid,SERIAL#
select * from dba_objects where object_id=12642;
-------------------------------------------------------------
select s.sid,s.SERIAL#,s.*,l.*,o.* from v$session s,v$locked_object l,dba_objects o where s.sid=l.session_id and l.OBJECT_ID=o.OBJECT_ID;
alter system kill session '932,1832';-----sid,SERIAL#
2516
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
