Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SGA being swap out?
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.
The main parameter is shared_pool_size . You will need to increase this.'
Check the tuning reference on this.
Thomas Ladew
Database administrator
In article <33f1c36c.2483690_at_news.netvigator.com>, alexyuen_at_ntvigator.com (Alex C.K. Yuen) writes:
>Hi Everyone,
>
>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?
>
>Any lights is greatly
>appreciated.
>
>Thanks in advance.
>Alex Yuen
>alexyuen_at_netvigator.com
Received on Thu Aug 21 1997 - 00:00:00 CDT