|
|
|
|
Re: ORA-00020: maximum number of processes (150) exceeded [message #349530 is a reply to message #349506] |
Mon, 22 September 2008 02:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68680 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
dilip56 wrote on Mon, 22 September 2008 09:02 | if you know the sid of the process, then you can get the spid of that particular process from v$process, and then kill that specific session from unix prompt using KILL command.
$> kill -9 spid
|
Another way: shutdown and restart the server.
Regards
Michel
|
|
|