Oracle-L: ORA-4031 errors no a high Load Database

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 27 Oct 2003 03:59:24 -0800
Message-ID: <F001.005D4AE2.20031027035924@fatcity.com>

Intermittent ORA-4031 errors Out of shared Pool :-

Oracle ver 9203

Solaris 9

Concurrent Users = 6000

Shared Servers / MTS being used

Listeners = 4

Application using Bind Variables

Application = Banking - Hybrid in Nature

Database size = 1 TB

m/c = SF15K

How can this issue be approached ?

Should we consider moving to Oracle 9204 / higher ?

large_pool_size                      big integer 2147483648

max_shared_servers                   integer     1000

mts_circuits                         integer     11000

mts_dispatchers                      string

(address=(protocol=tcp)(host=1

0.16.14.236))(listener=CONSOLD

                                                 GLIST)(dispatchers=7),

(addres

s=(protocol=tcp)(host=10.16.14

.236))(listener=OEMDGLIST)(dis

                                                 patchers=7),

(address=(protoco

l=tcp)(host=10.16.14.236))(lis

tener=BBYDGLIST6)(dispatchers=

7),

(address=(protocol=tcp)(ho

st=10.16.14.236))(listener=BBY

DGLIST2)(dispatchers=7), (addr

ess=(protocol=tcp)(host=10.16.

14.236))(listener=BBYDGLIST3)(

                                                 dispatchers=7),

(address=(prot

ocol=tcp)(host=10.16.0.215))(l

istener=BBYDGLIST4)(dispatcher

                                                 s=7),

mts_listener_address                 string

mts_max_dispatchers                  integer     150

mts_max_servers                      integer     1000

mts_multiple_listeners               boolean     FALSE

 

mts_servers                          integer     300

mts_service                          string      bby01

mts_sessions                         integer     10995

shared_pool_reserved_size            big integer 367001600

shared_pool_size                     big integer 1056964608

Will provide any Data needed

Thanks

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.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 Mon Oct 27 2003 - 05:59:24 CST