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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ora-4031- Advice on what to look at next time

Re: ora-4031- Advice on what to look at next time

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Tue, 23 Apr 2002 12:48:23 -0800
Message-ID: <F001.0044CFBB.20020423124823@fatcity.com>


> Stephane - You comment we may have too much pinned and you're probably right there. Currently our pinning is done by a startup trigger than pins packages, procedures, functions and triggers (this is what I meant by "objects") and I took the "simple to code and ensure it pins everything that could possibly be used by our application in Forms or PLSQL packages).
> I'm now thinking of altering to pin all the application objects (as before) but only those other objects that are referenced by our application (as from dba_dependencies).
>
> You mention querying v$rowcache - I get the following:
> 1* select parameter,count,usage,gets,getmisses,modifications,flushes from v$rowcache
> 09:37:17 SQL> /
>
> PARAMETER COUNT USAGE GETS gmisses mods FLUSHES
> ------------------------- ----- ----- -------- ------- ----- -------
> dc_free_extents 40 16 7565 197 445 269
> dc_used_extents 27 9 192 103 192 192
> dc_segments 1048 1031 785209 1032 224 155
> dc_tablespaces 14 11 13825 11 0 0
> dc_tablespace_quotas 5 3 201 3 201 132
> dc_files 32 24 624 24 0 0
> dc_users 117 110 358671 110 0 0
> dc_rollback_segments 15 10 9877 9 25 24
> dc_objects 2371 2370 311300 2319 98 46
> dc_global_oids 1 0 0 0 0 0
> dc_constraints 1 0 0 0 0 0
> dc_object_ids 935 932 3607186 911 53 1
> dc_synonyms 246 241 74577 241 0 0
> dc_sequences 28 25 7393 25 6646 6646
> dc_usernames 113 101 121515 101 0 0
> dc_database_links 1 0 0 0 0 0
> dc_histogram_defs 2666 2662 492074 2669 224 224
> dc_outlines 1 0 0 0 0 0
> dc_profiles 2 1 4014 1 0 0
> ifs_acl_cache_entries 1 0 0 0 0 0
> dc_users 1 0 0 0 0 0
> dc_sequence_grants 39 38 718 38 0 0
> dc_histogram_data 1 0 0 0 0 0
> dc_histogram_data_values 1 0 0 0 0 0
> dc_user_grants 139 107 130351 107 0 0
>
> 25 rows selected.
>
> All our flushes are on sequences - which aren't kept. Is there anything else you can detect from this output?
> Thanks,
> Bruce Reardon

Ooops, sorry, my internal timer was almost set to Californian time when I jumped back into the plane. Slowly digesting the 9 hours but I guess that my posts are more idiotic than usual this week. I meant V$DB_OBJECT_CACHE. That said, the number of flushes is indeed high for sequences, but I don't think that it means anything - just the way sequences work. Lines to look for are those where getmisses is high compared to count. Only those linked to extent management are in this case. I believe that you should watch this (many extensions? Perhaps a bit of pre-sizing would help - or many sorts, perhaps), but it is unlikely to be related to your other problem.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Tue Apr 23 2002 - 15:48:23 CDT

Original text of this message

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