Re: SHMMAX problem with Oracle 7 on Unixware 2.1

Doug Barnes (dwb_at_rellNOSPAM.com) wrote:
: 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?

Here are the values as taken from the "rootpre.sh" script on the CD-ROM called "Oracle 7.1.6 for UnixWare 2.01":

	SHMMAX		20971520
	SHMSEG		      15
	SEMMNI		     100
	NPROC               1600
	HFSZLIM		0x7FFFFFFF
	SFSZLIM		0x7FFFFFFF
	HDATLIM		0x7FFFFFFF
	SDATLIM		0x7FFFFFFF
	HVMMLIM		0x7FFFFFFF
	SVMMLIM		0x7FFFFFFF

--
*******************************************************************
Martin F. Sohnius                             msohnius_at_novell.co.uk
Novell IS & T, Bracknell, England             +44-1344-724031 
*******************************************************************
*        if (status = UNDER_NUCLEAR_ATTACK)                       *
*               launch_full_counterstrike();                      *
*******************************************************************
(C) 1997 M.F.Sohnius -- free distribution on USENET
       (Not a spokesperson  -- just a cyclist!)