oracle 使用者和表解鎖

使用者解鎖

elect * from dba_users u where u.account_status ='OPEN';
select * from dba_users u where u.username='NF_NFZC';
alter user NF_NFZC account unlock;
select count(1) from v$session;
select count(1) from v$session cn where cn.STATUS='ACTIVE';
select * from v$parameter where name='processes';
           

表解鎖

--1、檢視被鎖住的表
SELECT S.SID,
       S.USER#,
       s.SQL_ID,
       S.USERNAME,
       OBJECT_NAME,
       MACHINE,
       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;
--表解鎖 alter system kill session 'sid,serial#';
alter system kill session '3553,68';
--根據sql_id查詢sql語句
select *
  from v$sqltext t
 where t.SQL_ID = '7zmmadz89u547'
 order by to_number(piece);