Re: Inactive Cursors

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 02 Jun 2002 07:57:34 +0200
Message-ID: <btcjfu89fb0o61r0hb9i68svc3crlga54s@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 Received on Sun Jun 02 2002 - 00:57:34 CDT