Re: Oracle spwaned server process

In article <71d5qc$nar_at_portal.gmu.edu>, yfeng_at_osf1.gmu.edu says...
>
>Is there anyway to change the size of server process for each
>Oracle session. I am using AIX4.1, each server process takes
>about 5M. It's too much for our system, we have 1300 process and
>only 2gig of memeory.

We had exactly the same problem when we upgraded 7.1 -> 7.3, the resident set size of the dedicated server processes _tripled_.

Only solution was to put in some more memory and enable the Multi-Threaded-Server. MTS introduces a few eccentricities into the system all of its own, so read the manual before you set it up. In particular pay attention to the section regarding long running jobs and MTS. If your entire transaction load is OLTP, there shouldn't be any problem, but if you are trying to run batch jobs via MTS, then you'll find the shared servers getting blocked which will time out user connections out etc. If you are running a mix of transaction types, you'll need to find some way of seperating session types and allocating dedicated servers to long-running jobs.

On an older system we also found that with MTS enabled we couldn't even start the DB unless the entire SGA could be loaded into a single shared memory segment, so you may need to fiddle around with kernel parameters as well.

Good luck!

Cheers
Martin

--
Martin Rapier, Database Administrator
Corporate Information & Computing Services. University of Sheffield Tel 0114 222 1137 The opinions expressed here may be those of my employer, or they may not. http://rhino.shef.ac.uk:3001/mr-home/
Random quote of the day:
~! Received on Mon Nov 02 1998 - 09:12:50 CST