Pinned objects reloading?

From: Margaret Murray <mmurray_at_delorme.com>
Date: Tue, 16 May 2000 11:39:15 -0400
Message-Id: <10499.105748@fatcity.com>

Hi All,
Can anyone explain why objects pinned using execute dbms_shared_pool.keep are loaded more than once? I think that logically if it's pinned it shouldn't reload, especially for only 8K (see example below). Any explanations?

The pinning is done at database startup: execute dbms_shared_pool.keep('APPS.APPS_DDL','P'); execute dbms_shared_pool.keep('GL.APPS_DDL','P');

A little later, I do:

select loads,substr(type,1,10) TYPE,kept,executions,substr(owner,1,10) OWNER,
substr(name,1,15) NAME, sharable_mem
from v$db_object_cache
where loads > 1 and kept = 'YES' and name = 'APPS_DDL';

LOADS TYPE KEP EXECUTIONS OWNER NAME SHARABLE_MEM

---------- --- ---------- ---------- --------------- ------------

         3 PACKAGE    YES         10 GL         APPS_DDL                8759

         3 PACKAGE    YES          2 APPS       APPS_DDL                8781

Other information which may be pertinent: RDBMS 8.0.4.3 running Oracle Applications 11.02

Total System Global Area 1535359168 bytes

Fixed Size                       47296 bytes

Variable Size                352501760 bytes

Database Buffers            1174405120 bytes

Redo Buffers                   8404992 bytes

shared_pool_reserved_min_alloc 2621440

shared_pool_reserved_size 10485760

shared_pool_size 314572800 Received on Tue May 16 2000 - 10:39:15 CDT