Re: SHMMAX problem with Oracle 7 on Unixware 2.1

Tim Simpson wrote:
>
> 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
>
> ¦
> ¦Total System Global Area 37556140 bytes
> ¦ Fixed Size 48600 bytes
> ¦ Variable Size 20959700 bytes
> ¦ Database Buffers 16384000 bytes
> ¦ Redo Buffers 163840 bytes
> ¦
>
> 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

THE SHMMAX variable just sets the maximum shared memory size a process can create. The variables inside the init.ora are the ones used to create a shared memory segment for Oracle. You cannot have a shared memory segment as large as real memory since you need to have some of the OS BUT you should be able to build to set SHMMAX to a fairly large number but you need to have memory for other user processes besides Oracle (i.e. logging in, mail, ...). Are you recompiling the kernel after you change you tunable parameters?

-- 
Remove the NOSPAM to E-mail me.  Tired of the MLM schemes.