Re: Solaris/Intel Oracle 8i Memory

Nope. I have that set to zero. That was my first guess, as well.

• Paul

On Fri, 09 Jun 2000 23:55:16 GMT, "Van Messner" <vmessner_at_bestweb.net> wrote:

>Could it be that sort_area_retained_size is large?
>
>Van
>
>
>Paul Bennett <bennett_at_risklabs.com> wrote in message
>news:39413abc.274250671_at_news.comstar.com...
>> 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
>
>
Received on Mon Jun 12 2000 - 00:00:00 CDT