Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SGA being swap out?

Re: SGA being swap out?

From: <thomasl_at_expansion.com>
Date: 1997/08/21
Message-ID: <5tgoh5$87g@suriname.earthlink.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US