Re: SGA being swap out?

In article <5tgog8$87g_at_suriname.earthlink.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-Telecom.Unisource.NL
DISCLAIMER:This statement is not an official statement from, nor
           does it represent an official position of, PTT Telecom BV.