Re: Inactive Cursors

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 2 Jun 2002 06:02:43 -0700
Message-ID: <a8aed4.0206020502.627d4232@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 Received on Sun Jun 02 2002 - 08:02:43 CDT