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

Does your event by any chance produce a tracefile that could be used for anything?

Mogens

Stephane Faroult wrote:

>
>>----- Original Message -----
>>From: "Reardon, Bruce (CALBBAY)"
>><Bruce.Reardon_at_comalco.riotinto.com.au>
>>To: Multiple recipients of list ORACLE-L
>><ORACLE-L_at_fatcity.com>
>>Sent: Sun, 21 Apr 2002 22:23:18
>>
>>Our production instance started getting ora-4031
>>errors around 6pm on Frida=
>>y 19th.=0D
>>I was called by our users around 9am on Sunday 21st
>>and problem persisted a=
>>nd I decided to restart the instance around 11:30am
>>Sunday 21st.=0D
>>=0D
>>What I would like is some advice on what other
>>information I should collect=
>>next and advice on any settings that may need
>>altering.=0D
>>
>
>Bruce,
>
> You mention that you have all of your application objects (I presume you mean 'packages') and all Oracle standard stuff kept in shared memory. AFAIK it's precisely by pinning packages in memory that you avoid the problem you have. However, pinning EVERYTHING is perhaps a bit too much - you must pin only the biggest chunks to limit fragmentation. If I were you, what I'd check first would probably be V$ROWCACHE to check what is anchored and what is following the ebb, try to spot what causes the problem (what is reloaded most often?) and either pin it too or possibly unkeep some not-so-necessary stuff to get some breathing space.
>
>Stephane Faroult
>Oriole Corporation
>Performance Tools & Free Scripts
>--------------------------------------------------------------
>http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
>--------------------------------------------------------------
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?=
  INET: mln_at_miracleas.dk

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).