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