OraFAQ Forum: Unix » Kill Session

Home » Infrastructure » Unix » Kill Session (solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Kill Session [message #317784]

Sat, 03 May 2008 09:28

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

Report message to a moderator

Re: Kill Session [message #317787 is a reply to message #317784]

Sat, 03 May 2008 09:45

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator