Re: Any problems wth repeated pinning of a package?

From: Reid Lai <reidlai_at_hk.super.net>
Date: Mon, 02 Nov 1998 23:24:40 +0800
Message-ID: <363DCEB7.7C045A66@hk.super.net>

Oracle seems to use stack concept for memory usage. If there is anything not useful between the first and the second time you issue KEEP(). All these things are also pinned.
Therefore, Oracle recommends you should issue ALTER SYSTEM FLUSH SHARED POOL before you keep objects.

K POON wrote:

> I can't see any bad things, as I do the repeating pinning twice a day.
>
> K POON
>
> Dana Stockler wrote:
>
> > Are there any BAD THINGS that could occur if I repeatedly
> > pin a package, say once an hour, using dbms_shared_pool.keep?
> >
> > To put it another way, if a package is already pinned in
> > memory can anything bad happen if I pin it again?
> >
> > TIA,
> > Dana Stockler

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Certified Oracle 7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Nov 02 1998 - 09:24:40 CST