Re: v$db_object_cache loads

Do application users connect using their own usernames, or an application username? If the former, I believe you would get a separate load for each user (ie for each distinct parsing schema)

Regards Nigel

On 26 May 2011 19:53, Jay Hostetter <hostetter.jay_at_gmail.com> wrote:

> Can anyone tell me why I have some objects being reloaded in the SGA, even
> though they are pinned? To my knowledge, no dependent objects are being
> modified. I had posted a similar question last year when this DB was still
> on 9i. One answer was that PRAGMA AUTONOMOUS could force reloads. But that
> is not the case (at least with the trigger). I'm trying to make sure that
> there isn't some odd activity that is causing this to happen. ASMM is
> turned on with a target of 20 Gb. The shared_pool is around 1 GB, so I don't
> think it is any space pressure. Auditing is turned on in order to catch any
> DDL (and none is occurring).
>
> Oracle 10.2.0.5 on Win 2008 R2
>
> Thank you,
> Jay
>
>
> SQL> select owner,name,type,kept,loads,executions,
> 2 sharable_mem
> 3 from v$db_object_cache
> 4 where name in ('DBMS_ADVISOR','TIU_ROLLS');
> OWNER NAME TYPE KEP LOADS EXECUTIONS
> SHARABLE_MEM
> ------------ --------------- ------------ --- ---------- ----------
> ------------
> SYS DBMS_ADVISOR PACKAGE YES 3008 0
> 75416
> SYS DBMS_ADVISOR PACKAGE BODY YES 1443 345316
> 36872
> BIS TIU_ROLLS TRIGGER YES 1684 2884642
> 25634
>

--
http://www.freelists.org/webpage/oracle-l