Re: Inactive Cursors

"Ganesh Raja" <ganesh_at_gtfs-gulf.com> wrote in message news:a8aed4.0206020502.627d4232_at_posting.google.com...
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
news:<btcjfu89fb0o61r0hb9i68svc3crlga54s_at_4ax.com>...
> > On 1 Jun 2002 12:36:45 -0700, ganesh_at_gtfs-gulf.com (Ganesh Raja)
> > wrote:
> >
> > >Hi,
> > >
> > >Why do you need to Restart the server.
> > >
> > >Wont Alter System flush Shared_Pool;
> > >
> > >Do the trick. Correct me if i am wrong.
> > >
> > >[I Know it is Wrong advice but still wanted to clarify]
> > >
> > >Regards,
> > >Ganesh R
> > >
> > cursors are not located in the shared pool, but in the users PGA and
> > UGA
> >
> > Hth
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> If that is the case then killing the session or Disconneting te
> session will clear them right ??? Why Bounce the server ???
>
> That Bounce server Confused me a Bit .. Sorry for the Jubk question.
>
> Regards,
> Ganesh R

To change the open_cursors parameter you need to bounce the server. The original poster stated he couldn't do that.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address