Monday, July 03, 2006

Example: oracle search session to kill session

SQL> SELECT s.INST_ID ,s.sid,
p.spid,
s.osuser,
s.program,a.SQL_TEXT
FROM gv$sqltext a, gv$process p,
gv$session s WHERE s.sql_address = a.address and s.sql_hash_value = a.hash_value and p.addr = s.paddr and s.machine='mch' and s.osuser='van'
SQL> /

INST_ID SID SPID OSUSER PROGRAM
---------- ---------- ------------ ------------------------------ ------------------------------------------------
SQL_TEXT
----------------------------------------------------------------
1 230 1760 van sqlplus@DB(TNS V1-V3)
SELECT * FROM AH@LINK WHERE CUSID=:B3 AND CREATEDATE > :B2 AN

1 230 1760 van sqlplus@DB(TNS V1-V3)
D CREATEDATE <= :B1

2 223 15350 van sqlplus@DB (TNS V1-V3)
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;

2 223 27604 van sqlplus@DB (TNS V1-V3)
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;

>>> After that we can use "alter system kill session ..."
But this case we can use : # kill -9 1760

No comments: