DBMS_SHARED_POOL for Cursors

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1997/05/13
Message-ID: <33793F31.3E27@cadvision.com>#1/1

I have successfully executed DBMS_SHARED_POOL.keep for packages and I can see that they are indeed being kept via the v$db_object_cache view.

The DBMS_SHARED_POOL procedure permits the caching of CURSORS as well, and I have successfully done this as well. However, how can I display what cursors I have cached, and what behaviour can I expect from these cached cursors?

Wayne Linton, I.S.P.
Database Administrator
Shell Canada Ltd. Received on Tue May 13 1997 - 00:00:00 CDT