Re: What's the meaning of OPEN_CURSOR?

ajitsingh_at_hotmail.com wrote:
>
> In article <34C5668F.436E_at_comp.polyu.edu.hk>,
> Jimmy <c6635500_at_comp.polyu.edu.hk> wrote:
> >
> > Hello all,
> >
> > I developed Form4.5 and find that the max. of open_cursor is reached.
> > So I increased the value in the init.ora and works fine. But why my
> > application is reaching the limit of open_cursor? What's is the meaning
> > of open_cursor and why it works fine when I changed open_cursor to
> > larger value? And also what is the unit of open_curosr? Is this mean
> > memory? When I set to larger value, will the performance of Oracle (or
> > UNIX) be affected?
> >
> > Thanks,
> > Jimmy
>
> Hi,
>
> open_cursors parameter in init.ora is the max. no. of cursors that can be
> opened at any point of time. Larger value means that more cursors can be
> opened and more system memory will be used up. The application needs to
> close the cursors which are not in use.
>
> I hope this helps.
>
> Bye
> Ajit Singh
> Sr. System & DBA
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

One thing to note:

The setting in init.ora is the max open cursors per user. Received on Fri Jan 23 1998 - 00:00:00 CST