Re: SGA limit on Solaris x86

On 7 Oct, 12:02, "Mr. Chow Wing Siu" <wsc..._at_Comp.HKBU.Edu.HK> wrote:
> Dear all,
>
> SQL> show parameter sga;
>
> NAME                                 TYPE        VALUE
> ------------------------------------ ----------- ------------------------------
> lock_sga                             boolean     FALSE
> pre_page_sga                         boolean     FALSE
> sga_max_size                         big integer 4G
> sga_target                           big integer 4G
>
> Is it the problem?  What is sga_target and sga_max_size?
> How to increase?
>
> --
> Johnson Chow

As Vladimir Zakharychev stated earlier, you need 64-bit to address anything above 4Gb.

As Sybrand said, it is unlikely that you would gain anything even if you could address anything above 4Gb. I've even heard of occasions where increasing RAM has had a negative impact.

As for the parameters you mention, more information can be found here:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref376

HTH -g Received on Tue Oct 07 2008 - 05:50:49 CDT