Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: kept packages loaded multiple times???

Re: kept packages loaded multiple times???

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 23 Feb 2000 04:01:44 GMT
Message-ID: <38b3553f.507734924@news.eagles.bbs.net.au>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US