Re: SGA size and Solaris 8

ullas <ullas.radhakrishnan_at_oracle.com> wrote in message news:<3B440764.D6D32754_at_oracle.com>...
> Hi,
> I think you can have an SGA of size upto 1.75 GB without remapping.
> Ullas
>
> Steve Croft wrote:
>
> > If you want to use a large SGA (say >1G) do you still need to remap it
> > when on Solaris 8? I'm using 32-bit Oracle on 64-bit Solaris 8, by the way.
> >
> > All the digging I've done has only turned up references to earlier
> > Solaris versions.
> >
> > Thanks,
> > Steve Croft
>
> --

We are running Oracle 8.1.7 on Solaris 8 and remapped the SGABEG to give us an SGA size of 3 Gig. Here are the steps we followed:

Solution Description:

For RDBMS version 8.1.X , change your attach address by doing the following steps to relocate the SGA:

1. Shutdown any databases using the current "ORACLE_HOME".
2. Change your location to the "/lib" directory

      % cd $ORACLE_HOME/lib

3. Make a backup copy of 'libserver8.a'.

      % cp libserver8.a libserver8.a.orig

4. Change your location to the "rdbms/lib" directory

      % cd $ORACLE_HOME/rdbms/lib

5. Generate the "ksms.s" file

     % $ORACLE_HOME/bin/genksms -b <new_location> > ksms.s

     For example, changing the attached address starting at 
     0x80000000 to 0x60000000 would be: 

     % $ORACLE_HOME/bin/genksms -b 0x60000000 >ksms.s 
 

  The following table should help in selecting a value for the   attached address:

You need to configure the SGA to a value greater than 256 Mbytes on your

Sun system. You are referring to the following sgabeg parameter chart:

sgabeg = 0xe0000000 | 256Mb SGA 
sgabeg = 0xd0000000 | 512Mb SGA 
sgabeg = 0xc0000000 | 768Mb SGA 
sgabeg = 0xb0000000 | 1Gb SGA 
sgabeg = 0xa0000000 | 1.25Gb SGA 
sgabeg = 0x90000000 | 1.5Gb SGA 
sgabeg = 0x80000000 | 1.75Gb SGA 
sgabeg = 0x77000000 | just less than 2Gb SGA 
sgabeg = 0x70000000 | 2Gb SGA 
sgabeg = 0x60000000 | 2.25Gb SGA 
sgabeg = 0x50000000 | 2.5Gb SGA 
sgabeg = 0x40000000 | 2.75Gb SGA 
sgabeg = 0x30000000 | 3Gb SGA 
sgabeg = 0x20000000 | 3.25Gb SGA 
sgabeg = 0x10000000 | 3.5Gb SGA 
sgabeg = 0x01000000 | 16Mb less than 3.75Gb SGA 

6. Regenerate the 'ksms.o' object:

    % make -f ins_rdbms.mk ksms.o

7. Archive 'ksms.o' into 'libserver8.a'

    %ar r $ORACLE_HOME/lib/libserver8.a ksms.o

8. Relink

     % make -f ins_rdbms.mk ioracle Received on Wed Jul 25 2001 - 09:42:21 CDT