Oracle-L: RE: ORA-4031 error help.

From: Michael Milligan <Michael.Milligan_at_ingenix.com>
Date: Wed, 29 Oct 2003 15:04:25 -0800
Message-ID: <F001.005D4F86.20031029150425@fatcity.com>

It may have to do with an object not being able to load into SGA because of not enough contiguous memory in the SGA. It happens in MTS environments. Try pinning your larger objects.

-----Original Message-----
[mailto:Avnish.Rastogi_at_providence.org]
Sent: Wednesday, October 29, 2003 12:39 PM To: Multiple recipients of list ORACLE-L

Hello List, Need some help in resolving ORA-4031 error message. We are using Lawson and for last few days users are getting ORA-4031 error 2-3 times a day in LAWSON log files but there is no error message in alert log file or any trace file. Both shared pool and large pool is set to 1GB. Below is the current init.ora file. We are on Oracle 9202 and AIX 5.1, using MTS.

Thanks

# Miscellaneous

COMPATIBLE=9.2.0
DB_NAME=LAWSON
DB_FILES=1500
GLOBAL_NAMES=TRUE

DB_BLOCK_SIZE=8192
DB_CACHE_SIZE=1792M
DB_KEEP_CACHE_SIZE=16M

LARGE_POOL_SIZE=1024M
SHARED_POOL_SIZE=1024M

SGA_MAX_SIZE = 5G
DB_FILE_MULTIBLOCK_READ_COUNT=8
CONTROL_FILE_RECORD_KEEP_TIME=45

CURSOR_SHARING=SIMILAR
OPEN_CURSORS=750 # From Lawson--Raised from 500 to 750 10/24/03

BACKGROUND_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/bdump
CORE_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/cdump
USER_DUMP_DEST=/appl/lawdb/oracle/admin/LAWSON/udump

TIMED_STATISTICS=TRUE

CONTROL_FILES=("/appl/lawdb/oracle/data/db01/LAWSON/contrl_LAWSON_01.ctl",
               "/appl/lawdb/oracle/data/db02/LAWSON/contrl_LAWSON_02.ctl",
               "/appl/lawdb/oracle/data/db03/LAWSON/contrl_LAWSON_03.ctl",
               "/appl/lawdb/oracle/data/db04/LAWSON/contrl_LAWSON_04.ctl",
               "/appl/lawdb/oracle/data/db05/LAWSON/contrl_LAWSON_05.ctl")

# Archive

LOG_ARCHIVE_DEST=/appl/lawdb/oracle/archive_logs/LAWSON/
LOG_ARCHIVE_DUPLEX_DEST=/appl/lawdb/oracle/archive_logs_2/LAWSON/
LOG_ARCHIVE_FORMAT="ARC_LAWSON_%S.%T"
LOG_ARCHIVE_START=TRUE

# LOG_ARCHIVE_TRACE = 1

# Distributed, Replication and Snapshot

DB_DOMAIN=PHSOR.ORG
# Pools

JAVA_POOL_SIZE=0
# Processes and Sessions
# PROCESSES=800 Increased value per vendor JMK 6/09/03
PROCESSES=1000
SESSIONS=1140
ENQUEUE_RESOURCES=8000
TRANSACTION_AUDITING=FALSE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

FAST_START_MTTR_TARGET=1200
SORT_AREA_SIZE=0
HASH_AREA_SIZE=0
UNDO_MANAGEMENT=AUTO
UNDO_TABLESPACE=undo
UNDO_RETENTION = 10800

PGA_AGGREGATE_TARGET=1G
WORKAREA_SIZE_POLICY = AUTO
JOB_QUEUE_PROCESSES = 10
LOG_BUFFER = 8192000 # To reduce 'log file parallel write' wait event in v$system_event
CURSOR_SPACE_FOR_TIME = TRUE
SERVICE_NAMES=lawson_ax3202a
LOCAL_LISTENER=lawson_ax3202a
# Network Registration

INSTANCE_NAME=LAWSON
DISK_ASYNCH_IO = FALSE
BACKUP_TAPE_IO_SLAVES=TRUE

PARALLEL_THREADS_PER_CPU = 6
PARALLEL_MAX_SERVERS = 6
PARALLEL_MIN_SERVERS = 1

DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=provicon)(PORT=5000))(DISPATCHERS= 1)"
MAX_DISPATCHERS = 3
SHARED_SERVERS = 10
MAX_SHARED_SERVERS = 50 DISCLAIMER:
This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <Avnish.Rastogi_at_providence.org
  INET: Avnish.Rastogi_at_providence.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Michael Milligan
  INET: Michael.Milligan_at_ingenix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Wed Oct 29 2003 - 17:04:25 CST