Re: Pinning Packages in Memory?

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.

Check the dbmsspool.sql under $ORACLE_HOME/rdbms/admin. This script should give the information. If you need the exact steps let me know and I'll mail it to you.

Naren
naren_at_mink.att.com Received on Fri Aug 30 1996 - 00:00:00 CEST