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

Report message to a moderator

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: 68722
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

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.

Report message to a moderator

Re: Kill Session [message #320431 is a reply to message #320424] Thu, 15 May 2008 02:20 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't post in UPPER CASE.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 11 01:40:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.