Re: SGA being swap out?

Oh.. Yup. your right. bumping up the SGA to loarge will result in swapping out to disk. So if you bump up the SGA you have to take into consideration how large you swap size is. You might have to increase it.

Thomas

In article <5tgvrn$nfe_at_hdxl16.telecom.ptt.nl>, g.r.s.deisz_at_ptt-telecom.unisource.nl (g.r.s. deisz) writes:

>In article
><5tgog8$87g_at_suriname.e
>arthlink.net>,
>thomasl_at_expansion.com
>wrote:
>>Alex,
>>
>> you will need to
>tune your database to
>have a larger SGA size
>to minimize
>>SGA swapping out to
>disk. To do this you
>need to configure your
>init<SID>.ora
>>file.
>
>I think the original
>poster asked about how
>to prevent OS
>swapping. To prevent
>this you have to make
>the SGA small enough
>to completely fit in
>memory. Making
>it larger will only
>result in more
>swapping.
>
>> The main parameter
>is shared_pool_size .
> You will need to
>increase this.'
>
>There is also a
>parameter
>db_block_buffers which
>sets the number of
>cached
>database blocks.
>Depending on your
>application, this
>might be even more
>important.
>
>Regards, Stefan.
>
>>>Just curious will

 the SGA been
>>>swap out from

 physical memory to
>>>virtual memory? If

 so, any ways I
>>>can prevent so as to

 ensure
>>>performance?
>
>
>
>----------------------
>----------------------
>----------------------
>---
>Name :G.R.S.
>Deisz
>Phone
>:+31-50-5855954

 E mail
>:G.R.S.Deisz_at_PTT-Telec
>om.Unisource.NL
>DISCLAIMER:This
>statement is not an
>official statement
>from, nor
> does it
>represent an official
>position of, PTT
>Telecom BV.
Received on Sun Aug 24 1997 - 00:00:00 CDT