Home » RDBMS Server » Server Administration » Best way to kill a oracle session (oracle 10.2.0.4.0,windows,unix)
Best way to kill a oracle session [message #442266] Sat, 06 February 2010 04:57 Go to next message
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,
Re: Best way to kill a oracle session [message #442282 is a reply to message #442266] Sat, 06 February 2010 08:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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
Re: Best way to kill a oracle session [message #442411 is a reply to message #442266] Sun, 07 February 2010 21:52 Go to previous messageGo to next message
ramoradba
Messages: 2454
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
Re: Best way to kill a oracle session [message #442424 is a reply to message #442411] Sun, 07 February 2010 23:37 Go to previous message
Michel Cadot
Messages: 64153
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
Previous Topic: Transaction of Specific date locked
Next Topic: sqlplus / as sysdba gang
Goto Forum:
  


Current Time: Sun Dec 11 02:18:06 CST 2016

Total time taken to generate the page: 0.04236 seconds