From: oracle@tchp2.tcamuk.stratus.com (Neil Chandler) Subject: Re: Which package to PIN !!!! Date: 1998/02/02 Message-ID: #1/1 References: Organization: Stratus Computer Inc, Marlboro MA Newsgroups: cmg.centre.oracle,comp.databases.oracle,comp.databases.oracle.server,comp.databases.oracle.tools In article , "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. KSMLRHON - Name of the object. 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. > > > >