>----- Original Message -----
>From: "Reardon, Bruce (CALBBAY)"
><[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>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: Stephane Faroul
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
