Re: Pl/SQL Pinning

From: Kresimir Fabijanic <kresimir_at_ozemail.com.au>
Date: Sat, 05 Dec 1998 23:25:28 +1100
Message-ID: <36692637.98163B3_at_ozemail.com.au>

Martin

Use DBMS_SHARED_POOL.KEEP procedure. This procedure lets you keep an object in the shared pool.

dbms_shared_pool.keep(object IN VARCHAR2,

                                        [type IN CHAR DEFAULT P])

Input Parameters:

object

                Either the parameter name or the cursor address of the object

that you want kept in the shared pool. This value is the value displayed when you call the SIZES procedure.

type

                The type of the object that you want kept in the shared pool.
The types recognized are listed below:
                                                            P the object is a
procedure
                                                            C the object is a
cursor
                                                            R the object is a

trigger

Martin Brown wrote:

> I have forgotten the command to pin a PL/SQL routine into the shared pool.
> Can anyone remind of this command please?
>
> Cheers - Martin Brown
Received on Sat Dec 05 1998 - 13:25:28 CET