OraFAQ Forum: Server Administration » Best way to kill a oracle session

Home » RDBMS Server » Server Administration » Best way to kill a oracle session (oracle 10.2.0.4.0,windows,unix)

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

Best way to kill a oracle session [message #442266]

Sat, 06 February 2010 04:57

Hitman11
Messages: 94
Registered: October 2009
Location: norway

Member

Hi,

Which is the best way to kill a session?

alter system kill session sid,serail#
or
kill -9 spid
or
orakill sid,thread

I am using unix,windows operating system.

Regards,

Report message to a moderator

Re: Best way to kill a oracle session [message #442282 is a reply to message #442266]

Sat, 06 February 2010 08:56

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do you think the answer has changed since you posted your topic Kill back end session & Time taken to kill session

Read an other topic on the question: Not able to kill Oracle session

Regards
Michel

Report message to a moderator

Re: Best way to kill a oracle session [message #442411 is a reply to message #442266]

Sun, 07 February 2010 21:52

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

And every time its better to test the cases at your testing environment first..then if you have any problems/doubts/issues then post here...
And before that re read your posts/answers and links(documents)provided...Its Good for you.

Good luck
sriram Smile

Report message to a moderator

Re: Best way to kill a oracle session [message #442424 is a reply to message #442411]

Sun, 07 February 2010 23:37

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

In addition, feedback to the topic then we know that you have read the answers (and maybe you will not the question once more).

Regards
Michel

Report message to a moderator

Previous Topic:	Transaction of Specific date locked
Next Topic:	sqlplus / as sysdba gang

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 11 01:49:02 CDT 2024