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;
Thông tin hữu ích ^^
Trả lờiXóa