Re: Which package to PIN !!!!

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1998/02/03
Message-ID: <6b6epp$kpc$1_at_news02.btx.dtag.de>#1/1


On Mon, 2 Feb 1998 15:30:12 GMT, "Erik Oosterling" <Erik.Oosterling_at_nospam.cmg.nl> wrote:

Hi Erik,

generally you should pin:

EXECUTE SYS.DBMS_SHARED_POOL.KEEP('STANDARD');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('DBMS_STANDARD');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('DBMS_UTILITY');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('DBMS_DESCRIBE');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('PIDL');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('DIANA');
EXECUTE SYS.DBMS_SHARED_POOL.KEEP('DIUTIL');

Don't know what other stuff you need for forms 'cause I don't use it.

>Hi there,
>
>Which packages are used during a compile using Forms 4.5. I want to pin
>these package using DBMS_SHARED_POOL.KEEP for optimal performance.
>
>Thank you
>
>--
>please remove .NOSPAM from email addres for email replies.
>Apologies for cloaking my address.
>
>
>
>
Received on Tue Feb 03 1998 - 00:00:00 CET

Original text of this message