Re: Need help about optimizing SGA under VMS6.2

You may still have to adjust the global pages & sections using autogen and modparams.dat entries after you have relinked the oracle kernel and adjusted the size of the SGA Pad (process address space). To relink the kernel...
Shutdown oracle
then remove installed images with
$remoracle
Run the installation script
$ oracleins
From the installation startup menu
Choose to reconfigure existing products
Take the defaults <return> on the directory and save set options Choose software installation and upgrade menu Select build configurations
Select RDBMS to upgrade it's configuration Modify the value of the Size of SGA Pad (KBytes) parameter re-Build the RDBMS and wait while it relinks The kernel can now address more VMS memory so fill it up by enlarging the SGA parameters in init.ora.

Craig M. Wall

Vedran Kanizaj wrote in message <625kav$oed_at_argos.tel.hr>...
>I'm upgrading memory on Alpha 1000A , from 128MB to 256 MB running
 Oracle7.I
>have a problem when I want to enlarge the SGA. Currently the SGA uses 32
>MB,but when I try to go beyond 32MB then I'receive the following message:
>ORA -07639 smscre:SGA pad AREA not large enough.
>I've tried to enlarge gblsections from 800 to 1600 and gblpages from 300000
>to 600000, but the result stand the same.
>I would be very thankfull for some advice about it.
>Thanks in advance !
>
>
Received on Thu Oct 16 1997 - 00:00:00 CDT