This script will kill a session. Sometimes sessions are running wild – and you could need the ability to kill a session. Use copy paste ot the alter statement to kill sessions. SQL> @kill inactive KILL ORG STATUS ID ---------------------------------------- ----- -------- ------------------------------------ alter system kill session '175,666'; 106 INACTIVE 1020 13:13 dk1dakotsl07...APPS alter system kill session '180,1519'; 276 INACTIVE 1020 11:26 dk1dakotsl07...APPS alter system kill session '181,2794'; 106 INACTIVE 1020 12:56 dk1dakotsl07...APPS alter system kill session '183,2806'; 106 INACTIVE 1020 12:52 dk1dakotsl07../u20/app/TR alter system kill session '186,3937'; 106 INACTIVE 1020 13:13 dk1dakotsl07...APPS alter system kill session '187,555'; 1716 INACTIVE 1020 10:27 dk1dakotsl07...APPS alter system kill session '191,25'; INACTIVE 1020 09:32 dk1dakotsl07.unknown.JDBC alter system kill session '192,15'; 106 INACTIVE 1020 09:32 dk1dakotsl07.unknown.JDBC
Download: sql4oracle.zip - all sql4oracle scripts - posted 14-03-2013