Comments
| Killing Oracle Sessions - Kill Oracle sessions from SQL, NT and UNIX. |
| Dean said... Fantastic hint ! Note that on Oracle 7, the ALTER SYSTEM KILL ... IMMEDIATE option doesn't seem to exist. But who uses Oracle 7 anyway right?? (Only my stupid client..!!) |
| Tariq said... Thanks, it help a lot. |
| Vinod said... Thanks !!!!! It helped a lot. |
| Michael said... In Unix you should always first try a "smooth" "kill pid" and wait some seconds before hard killing "kill -9 pid" a process. The smooth kill (aka SIGTERM) give a process the chance to clean things up before terminating, whereas the hard kill doesn't. Sure, the hard kill alway terminates the process (except it is hanging in "kernel-space"), but if a process has open file,semaphores,etc. they won't be cleaned up. |
| Joe said... I completely agree with what Michael said. |
| Tim... said... Point taken. Article amended. :) Cheers Tim... |
| Damnit said... Hey, you should inform that kill -9 spid terminate all oracle process and shut it down .. because of you i'm on trouble !! .. so i'm not going to say thanks to you .. |
| Tim... said... Hi. If you don't understand that killing OS processes is dangerous you shouldn't be doing it! Killing processes associated with regular sessions is fine. If you kill a process associated a background process you are going to be in trouble. Don't blame me because you killed the wrong session. Cheers Tim... |
Don't ask technical questions here, that's what the forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!
