Re: v$db_object_cache loads

  • From: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
  • To: hostetter.jay@xxxxxxxxx
  • Date: Fri, 27 May 2011 18:18:52 +0100

Jay

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@xxxxxxxxx> 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
>

Other related posts: