DBMS_SHARED_POOL and Cursors

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1997/05/17
Message-ID: <337E8AFC.18B@cadvision.com>#1/1

The DBMS_SHARED_POOL.keep routine will 'pin' a package in the SGA. The documentation says that you can also do this for cursors (ORACLE7 V7.1). I have executed the 'keep' for both packages and cursors successfully. I can see that the packages are kept via the V$_DB_OBJECT_CACHE view.

Does anyone know what the effect of 'keep'ing a cursor is, and by what means I can verify that the cursor is indeed kept?

Wayne Linton
Shell Canada Ltd. Received on Sat May 17 1997 - 00:00:00 CDT