select rpad(oracle_username, 10) o_name,
session_id sid,
decode(locked_mode,
0, 'None',
1, 'Null',
2, 'Row share',
3, 'Row Exclusive',
4, 'Share',
5, 'Share Row Exclusive',
6, 'Exclusive') lock_type,
object_name,
xidusn,
xidslot,
xidsqn
from v$locked_object, all_objects
where v$locked_object.object_id = all_objects.object_id;
用下原的command來做解鎖動作
--alter system kill session '252,2404'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51635/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29987/viewspace-51635/