Database 11g

Wednesday, July 27, 2016

How to Kill the Session by Finding Logon Time in Oracle RAC



SQL> select username,inst_id,sid,serial# from gv$session where username='RNGLCA';

            USERNAME     INST_ID        SID    SERIAL#
          --------- ---------- ---------- -----------------------------
             RNGLCA                 1             1161      33560


SQL> select s.username,  s.sid,  s.serial#,p.spid, last_call_et,status,to_char(logon_time, 'hh24:mi dd/mm/yy')
    logon_time from GV$SESSION s,GV$PROCESS p where s.PADDR=p.ADDR and s.username='RNGLCA';

   USERNAME    SID      SERIAL#     SPID  LAST_CALL_ET       STATUS         LOGON_TIME
   --------- ---------- ---------- --------- ------------ -------- ---------------------------------------------------
      RNGLCA      1161      33560       14600         14                   INACTIVE        09:45 27/07/16
      RNGLCA      1161      33560       10320         14                   INACTIVE        09:45 27/07/16


SQL> ALTER SYSTEM KILL SESSION '1161,33560,@1';

System altered.


Happy Learning ):






No comments:

Post a Comment