Home » Infrastructure » Unix » Kill Session (solaris)
Kill Session [message #317784] Sat, 03 May 2008 09:28 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi all,


what is the difference of using command these two below commands?
kinldy reply me with the answer.


kill -9 spid

alter system kill session 'sid','serial#' immediate;

Regards,
Balaji.C
Re: Kill Session [message #317787 is a reply to message #317784] Sat, 03 May 2008 09:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
kill -9 immediatly kills the session and let PMON do the job to rollback the transaction and release lock.
ALTER SYSTEM KILL SESSION is explained in the doc with all its variants.

Regards
Michel
Re: Kill Session [message #320424 is a reply to message #317787] Thu, 15 May 2008 02:07 Go to previous messageGo to next message
cgk_js
Messages: 48
Registered: December 2005
Member
KILL IS AN UNIX ONE
AND ALTER SESSION IS AN ORACLE ONE.
Re: Kill Session [message #320431 is a reply to message #320424] Thu, 15 May 2008 02:20 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't post in UPPER CASE.

Regards
Michel
Previous Topic: script output in serial
Next Topic: Difference between PID and Job id
Goto Forum:
  


Current Time: Thu Mar 28 14:21:00 CDT 2024