Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: kept packages loaded multiple times???
Hello Jane,
It sounds as though you expect the packages to remain KEPT after a bounce? If so, you are mistaken. The DBMS_SHARED_POOL.KEEP calls need to be repeated each time the instance is started.
Regards,
Steve Adams
http://www.ixora.com.au/ http://www.oreilly.com/catalog/orinternals/ http://www.christianity.net.au/
On Fri, 18 Feb 2000 15:43:08 -0600, "Jane Schrock" <jschrock_at_us.ibm.com> wrote:
>I am pinning 4 packages when I start my database using
>dbms_shared_pool.keep. However, when I query v$db_object_cache, I see that
>two of them have loads > 1. DBMS_APPLICATION_INFO has 56 loads and
>DBMS_OUTPUT has 55 loads. I pinned these packages and bounced the database
>last night and this is what I see today. I'm on Oracle 8.0.4.4. On my
>Oracle 7 databases with pinned packages I always see loads=1. Does anyone
>have any idea what's going on? My shared pool size is 15M.
>
>Jane
>
>
Received on Tue Feb 22 2000 - 22:01:44 CST