Re: Which package to PIN !!!!

In article <EnrFB7.3q6_at_atf.cmg.nl>, "Erik Oosterling" wrote:

I don't know that off the top of my head but you should find this useful:

If you logon as SYS and 'SELECT * from X$KSMLRU;', you will be presented with a top ten list of cursors and stored procedures which have caused objects to be kicked out of the shared-pool so that they could get in. These are usually the best candidates for pinning. Repeat until the baddies have gone away. NOTE: After you select from this table, it autodeletes the contents. COlumns of note:

KSMLRCOM - Type of object (e.g. Bam: Buffer = stored proc)
KSMLRSIZ - Size of object >5K warrant a second look. >25K could be a real prob.
KSMLRNUM - Number of objects discarded from the shared_pool so this object
           could get in.

regs

Neil Chandler

>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 Mon Feb 02 1998 - 00:00:00 CET