Re: ORACLE ERROR : ORA-00020
From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 16 Feb 2001 00:29:11 +1100
Message-ID: <3a8bd9a8$1_at_news.iprimus.com.au>
Date: Fri, 16 Feb 2001 00:29:11 +1100
Message-ID: <3a8bd9a8$1_at_news.iprimus.com.au>
Not sure -but there's an init.ora parameter called "processes=xxx" which defaults to a mere 50 (Yet another stunningly intuitive and wise Oracle default!). Might want to look into upping that, and then bouncing your Instance. See how that goes.
Regards
HJR
"rocco" <roccodalto_at_tiscalinet.it> wrote in message
news:3A8BD6A3.DD500FF2_at_tiscalinet.it...
> Hi to everyone
> I had this error during the execution of a select (via SqlNet using
sqlplus) :
> ORA-00020 maximum number of process execeed.
> I'd want to know if there is a system table where I can read the numbers
of
> opened process.
> Thanks.
>
Received on Thu Feb 15 2001 - 14:29:11 CET