oracle 数据库加锁 解除 session查看

----查询在线EBS用户
SELECT distinct u.user_name
  FROM ICX_SESSIONS          ICX,
       FND_USER              U,
       FND_APPLICATION       APP,
       FND_APPLICATION_TL    FAT,
       FND_RESPONSIBILITY    FR,
       FND_RESPONSIBILITY_TL FRT,
       FND_FORM_FUNCTIONS    FFF,
       FND_FORM_FUNCTIONS_TL FFT
WHERE 1 = 1
   AND U.USER_ID = ICX.USER_ID
   AND ICX.RESPONSIBILITY_APPLICATION_ID = APP.APPLICATION_ID
   AND FAT.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID
   AND FAT.LANGUAGE = 'ZHS'
   AND FR.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID
   AND FR.RESPONSIBILITY_ID = ICX.RESPONSIBILITY_ID
   AND FRT.LANGUAGE = 'ZHS'
   AND FRT.APPLICATION_ID = ICX.RESPONSIBILITY_APPLICATION_ID
   AND FRT.RESPONSIBILITY_ID = ICX.RESPONSIBILITY_ID
   AND FFF.FUNCTION_ID = ICX.FUNCTION_ID
   AND FFT.FUNCTION_ID = ICX.FUNCTION_ID
   AND ICX.DISABLED_FLAG != 'Y'
   AND ICX.PSEUDO_FLAG = 'N'
   AND (ICX.LAST_CONNECT +
       DECODE(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),
               NULL,
               ICX.LIMIT_TIME,
               0,
               ICX.LIMIT_TIME,
               FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT') / 60) / 24) >
       SYSDATE
   AND ICX.COUNTER < ICX.LIMIT_CONNECTS;


  ----kill 加锁 对象
  SELECT 'alter system kill session ' || '''' || sid || ',' || serial# || '''immediate;', a.* 
  FROM dba_ddl_locks a, v$session ss 
WHERE a.name ='CUX_JL_R0430170_PKG' 
   AND a.session_id = ss.sid; 
  
   -----
  
   Select s.Type,s.Action,s.Sid,s.Status,s.Schemaname,s.Osuser,s.Machine,S.PROCESS,
       'ALTER SYSTEM KILL SESSION ''' || s.Sid || ',' || s.Serial# || ''';'
  From V$session s, V$access Se
Where s.Sid = Se.Sid
   And Se.Object  in  ('CUX_JL_R0430170_PKG');
  
   select xidusn, object_id, session_id, locked_mode from v$locked_object;
  
   alter system kill session '29,57107';
  
ALTER SYSTEM KILL SESSION '594,4197';