系统不正常 ,条数只增不减 ,感觉是停到了某个位置
一下想到oracle 锁表了
1
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
2
540 =sid
3891 =serial
alter system kill session'540,3891';
注意:1把服务停了在杀,否则乱套。
2 别看很多 ,里面大部分重复的记录