Re: open_cursors limitation

From: Peter H. Larsen <plarsen.nospam_at_dc.dynares.com>
Date: Mon, 06 Jul 1998 14:47:09 -0400
Message-ID: <35A11BAD.5EE924E6@dc.dynares.com>

Hi,
Talk to your DBA ... he can increase the OPEN_CURSORS parameter in the "init.ora" (internal parameters) for the instance. Some platforms doesn't support more than 250 open cursors pr. session. But heck ... that should support most peoples requirements :))

Peter H. Larsen

Kevin wrote:
>
> Does anyone know what the limitation is for open_cursors on a Unix
> system? I know that the default is 50. I created a recursive algorithm
> that is used to print out a hierarchy listing. I was just wondering how
> many levels I can put in this thing before the listing would crash. If
> I can get more than 50 (default) how would I go about increasing that
> number?
>
> Thanks,
> Kevin

Peter H. Larsen, Oracle and Applications specialist Dynamic Resources Inc, Alexandria
Phone: 703-914-9800 #103
Fax: 703-914-9804
Email: plarsen_at_dc.dynares.com
(please remove the nospam from the header when replying to this email)

The above views are my own and does not reflect the views of my employer. Received on Mon Jul 06 1998 - 13:47:09 CDT