Re: Solaris/Intel Oracle 8i Memory

Yea, I realize MTS will help me with my memory problem, but I would still like to know why the dedicated connections are taking 20 megs. Is it some java thing? In 8.0.5 the connections are like 300k or something like that.

• Paul

On Mon, 12 Jun 2000 08:49:12 -0400, Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:

>Paul Bennett wrote:
>>
>> I am running Oracle 8i on solaris/intel.
>>
>> My qyestion: How come dedicated server processes take up so much
>> memory? Now, I am not talking about the SGA that gets reported on
>> each processes, I am talking about private memory used for each server
>> connection. Ever time I connect to the database, I eat about 3 megs
>> of RAM and about 20 megs of swap, consistently. I can have 500 megs
>> of swap available and 120 megs of RAM available, and connect to the
>> database. It will drop my swap by 20 megs and take 3 megs out of RAM.
>> Note: I am not looking at ps and getting shared memory confused with
>> actual private memory allocated per dedicated server processes.
>>
>> What is causing oracle to take such a big chunk? My SGA is about 35
>> megs. Is there something wrong with my shared memory setup that is
>> causing these server processes to allocate a crap load of private
>> memory for some reason?
>>
>> I have run 200 users dedicated on 256 megs of RAM on NT before without
>> this swapping problem because each dedicated processes only took up
>> 300k or so.
>>
>> Thanks.
>>
>> -- Paul
>
>You may want to consider configuring multi-threaded-server. It will cut
>down on overall memory usage since the server processes are reused.
Received on Mon Jun 12 2000 - 00:00:00 CDT