|
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
|
- RE: ORA-4031 errors no a high Load Database VIVEK_SHARMA
- RE: ORA-4031 errors no a high Load Database Stephen.Lee
- Re: ORA-4031 errors no a high Load Database Tim Gorman
