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

 

 

Reply via email to