Re: set event 4031

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Sun, 02 Sep 2001 08:34:39 -0700
Message-ID: <F001.00380638.20010902083037@fatcity.com>

Henry,

The event will cause a trace file to be generated for any session that encounters an ORA-4031. Is it possible that it wasn't one of the sessions being logged that generated the error? If you look in the trace file you should see the current SQL being executed that may give you more info about the session generating the error.

Also, be aware that there's a bug on 8.1.6.3 where ORA-4031's can occur attempting to allocate state objects, often accompanied by heavy latch contention on the 'cache buffer chains' latch. This is bug 1640583. You might want to check with support as there are PSE's (patchset exceptions) available for several platforms.

This is not the same as bug 1397603 where ORA-4031's are also reported when allocating state objects. This bug is specific to 8.1.7 and the workaround is to set _db_handles_cached = 0.

HTH,

• Anita
  • Henry Poras <Henry.Poras_at_ctp.com> wrote:
    > We have been having occasional ORA-4031 problems. I
    > will probably need to
    > increase the shared_pool, but before doing that I
    > wanted to get some extra
    > information. Yesterday I entered ALTER SYSTEM SET
    > EVENTS '4031 trace name
    > heapdump level 2'. This morning I found a few trace
    > files in the udump
    > directory. They all seemed to show enough free space
    > (I looked at the size
    > of the free space chunks in the FREE LIST section)
    > so I didn't understand
    > why we would have the 4031. I asked one of our
    > developers to send me the log
    > file of the application where the 4031 shows up, and
    > he said there were no
    > such errors last night. This is consistent with the
    > amount of free space in
    > the shared_pool, but why am I getting the trace
    > files? Anybody else seen
    > this? I am on 8.1.6.3
    >
    > Thanks.
    >
    > Henry
    > --
    > Please see the official ORACLE-L FAQ:
    > http://www.orafaq.com
    > --
    > Author: Henry Poras
    > INET: Henry.Poras_at_ctp.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).
    

    ---

Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.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 Sun Sep 02 2001 - 10:34:39 CDT