Re: v$db_object_cache loads
- From: Jay Hostetter <hostetter.jay@xxxxxxxxx>
- To: Nigel Thomas <nigel.cl.thomas@xxxxxxxxxxxxxx>
- Date: Wed, 1 Jun 2011 15:20:03 -0400
Nigel,
No - most of the users connect under one application username.
Thank you,
Jay
On Fri, May 27, 2011 at 1:18 PM, Nigel Thomas <
nigel.cl.thomas@xxxxxxxxxxxxxx> wrote:
> 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:
