Re: open_cursors limitation

From: Scanavino Roberto <roberto.scanavino_at_rsisistemi.it>
Date: 15 Jul 1998 13:55:36 GMT
Message-ID: <01bdafec$abecafc0$38cab9c2@drake>

You must search initORCL.ora (if the instance name is 'ORCL') on your server then you add or change the following line:

open_cursors = 150

Remember to stop and restart your database.

Bye Roberto

Kevin <kjk_at_hrb.com> scritto nell'articolo <35A0E45B.4E60_at_hrb.com>...
> 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
>
Received on Wed Jul 15 1998 - 08:55:36 CDT