Re: ORA-00020 Error

"Brian Peasland" <dba_at_nospam.peasland.net> wrote in message news:JBo7JD.387_at_igsrsparc2.er.usgs.gov...
> 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

Thanks Brian,

Now I can see from SQL+.

Is there any tool to monitor this from GUI. I am using Oracle 9i.

SK Received on Wed Jan 10 2007 - 16:30:15 CST