Re: MAX CURSORS IN REPORTS 6.0

From: Zafer AKTAN <zafer_at_redshift.com>
Date: Mon, 3 Apr 2000 21:44:17 -0700
Message-ID: <seis8h9eop17_at_corp.supernews.com>

You can log in to the database server and start server manager (svrmgrl on unix) and then type connect internal. Then type shutdown normal (enter). Before shutting down the database ensure that no body is accessing to the database. You can check this querying the v$session table. After the database is down, modify the init.ora file (you might called it differently like initoracle8.ora etc. but you will find it). To find it type (in unix) find . -name "ini*.ora" -print
Add the parameter open_cursors = 500 to your init.ora file (default is 50). Then start your database (from server manager) - by typing: startup

If necessary you may increase the open_cursors parameter value.

When writing the code try to close each cursor after the execution is done. But as the master of PL/SQL points out, there is a trade of between explicitly closing the cursors and the speed. I think you should consider both.

regards
Zafer AKTAN, DBA/Developer

<jehall_at_my-deja.com> wrote in message news:8bt12e$q0i$1_at_nnrp1.deja.com...
> In article <954274383.28301.1.pluto.d4ee154e_at_news.demon.nl>,
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> >
> > <jehall_at_my-deja.com> wrote in message
> news:8br2kd$lsd$1_at_nnrp1.deja.com...
> > > Hi. I have a very complex report that has tons of Column Functions
> that
> > > do SELECT INTO's etc...I know that with this statement an explicit
> > > cursor is openend behind the screen. If I try to add any more CF, I
> get
> > > an error message stating that there are too many cursors open!!! Is
> > > there a way I can free up the cursor after each SELECT INTO? I know
> > > there is a close, but what is the implicit cursor name - Please
> Help!!!
> > >
> > > Thanks.
> > >
> > > Jason.
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> > Increase the init.ora parameter open_cursors and bounce the database ,
> there
> > is NO way to close an implicit cursor, and AFAIK Oracle takes care of
> that
> > automatically.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> >
> How do you do that??? Where do I go?

>

> Jason.

>
>

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Apr 04 2000 - 06:44:17 CEST