RE: ORA-4031 errors no a high Load Database

From: <Stephen.Lee_at_DTAG.Com>
Date: Mon, 27 Oct 2003 09:04:25 -0800
Message-ID: <F001.005D4B1A.20031027090425@fatcity.com>

There is/(are) known bug/(s) in 9.2.0.3 where the shared pool becomes fragmented and will refuse to un-fragment itself. Attempts to flush the shared pool fail. So far, based own our experience here, this seems to be fixed in 9.2.0.4.  

Things like shared pool details tend to leak out of my head despite multiple readings of the material ... but I would comment that a 1 gig shared pool with a 2 gig large pool and a 350 meg shared pool reserve seem a bit unusual.    

-----Original Message-----
Sent: Monday, October 27, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L  

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 inte056964608

 

 

Will provide any Data needed  

Thanks    

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <Stephen.Lee_at_DTAG.Com
  INET: Stephen.Lee_at_DTAG.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 - 11:04:25 CST