Re: Pinning Packages in Memory?

From: <mthomas_at_digital.net>
Date: 1996/09/04
Message-ID: <322E1BBB.5BF2_at_digital.net>#1/1


Hi Andrew --
I have used this command:
DBMS_SHARED_POOL.KEEP('packagename');

Supposedly you can "un-pin" if you wish (I didn't)... DBMS_SHARED_POOL.UNKEEP('packagename');

Funny, this command is written up in Mastering Oracle7 and Client/Server Computing by Steven Bobrowski -- really kind of an overview type book!!

Mary Thomas



Andrew Zitelli wrote:
>
> I have recently written several large packages for use with Oracle 7.2.3
> under HP/UX 10.01. The performance of these packages is very important
> so I would like to pin them into memory. I know I have seen previous
> discussions in this newsgroup regarding pinning packages in memory,
> immediately after a database instance is started up. Unfortunately, I
> have not saved any of those postings. I have searched my Oracle 7.1 and
> 7.2 manuals, but cannot find where this is discussed. I know I have
> read about this within the past few months.
>
> Can anyone either provide complete instructions on how to do this, or
> refer me to the proper manual or book? I do have a large collection of
> Oracle reference books in addition to complete sets of Oracle manuals.
> Thanks for any assistance!
>
> -- Andy Zitelli, Silicon Systems, Inc.
Received on Wed Sep 04 1996 - 00:00:00 CEST

Original text of this message