Re: ORA-00020 Error

design wrote:
> I am using application server and jdbc to connect with database.
> After connecting a couple of times the following error displayed.
>
> Error in allocating a connection. Cause: Connection could not be allocated
> because: ORA-00020: maximum number of processes (150) exceeded
>
> I want to monitor the number of processes used at the database
> How can i do?
>
>

Have a look at the V$RESOURCE_LIMIT view. It will show you the current usage, the max usage, and the limit.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown