@kill

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 @kill (0 downloads)

Leave a Reply