SHMMAX problem with Oracle 7 on Unixware 2.1

Hello,

Can some one please give advice on setting the SHMMAX param for Oracle 7 on Unixware 2.1

The Oracle installation manual states that this should be 20mb on unixware

but in other oracle documentation you are told that SHMMAX should be large enough to hold the SGA

we wish to increase the size of the variable size and have tried increasing SHMMAX
from 20mb to 25mb and then to 30mb but in each case we still get the four memory segments
and are not allowed to increase the variable size above 20mb

should we increase the size to 40mb to hold the entire sga and hence would we then
be able to increase the size of the sga

sho sga reports the following

                                                            =



=A6                                                  =





=A6Total System Global Area      37556140 bytes                          =





=A6              Fixed Size         48600 bytes                          =

=A6

hope all this makes sense (I know little about oracle I'm afraid)

• =

With best wishes

Tim

Tim Simpson                                   |    Dundee City Council
Tel:  +44 (0) 1382-438184                     |    I.T. Divison
Fax:  +44 (0) 1382-438002                     |    Technical Block
Mobile: 0976-714809                           |    Northern College =

Email: tsimpson_at_dundeecity.gov.uk             |    Gardyne Road   =

                                              |    Dundee  =

 We can sit and play twenty questions         |    Scotland
  while our leaders invent the answers        |    DD5
1NY                  =

                      =

Visit our Web Site http://www.dundeecity.gov.uk Received on Fri Sep 12 1997 - 00:00:00 CEST