select * From v$locked_object
select * From v$session where SID = '<>'
select * from dba_objects where object_id = '<>'
-- Locked objects
Select object_name, owner, object_type from dba_objects
Where object_id in (select object_id from v$locked_object);
-- KILL SESSION COMMAND
ALTER SYSTEM KILL SESSION '38,53336' IMMEDIATE;
Tuesday, August 5, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment