In article <962444783.22059.0.nnrp-13.9e984b29_at_news.demon.co.uk>,
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> It's probably worth checking that statement for
> each type of object in your specific version of Oracle.
> I think the v7 documentation used to state quite
> explicitly that KEEP could only keep objects that
> were already loaded; the same is not true for 8.1.5.
> (at least for sequences) - try the following test:
>
From experience and several tar reports I believe that
dbms_shared_pool.keep would load and pin the package specification, but
not the body, into the shared pool with ver 7. We had to add a dummy
routine to every large package and on instance start-up we pin'd every
package then executed this dummy routine in each package. This
eliminated the daily occurance of shared pool memory errors and
'program unit not found' messages. There were a lot of posts on this
subject back in 1995.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Jul 01 2000 - 00:00:00 CDT
