RE: ORA-4031 errors no a high Load Database

[Stephen.Lee]

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----- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 5:59 AM To: Multiple recipients of list ORACLE-L Subject: ORA-4031 errors no a high Load Database   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