Thứ Ba, 10 tháng 9, 2013

lock session and kill log session in oracle database (single node)

1) check information of lock object in oracle database, we need run command below:
select a.session_id,
c.SERIAL#,
a.oracle_username,
a.os_user_name,
b.owner "OBJECT OWNER",
b.object_name,
b.object_type,
a.locked_mode
from (select object_id,
SESSION_ID,
ORACLE_USERNAME,
OS_USER_NAME,
LOCKED_MODE
from v$locked_object) a,
(select object_id, owner, object_name, object_type from dba_objects) b,
v$session c
where a.object_id = b.object_id
and a.session_id=c.SID;
2) kill session show in result above with command:
ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

1 nhận xét: