Oracle SGA on SCO

Andrew Ryan (genanr_at_amiserv.xnet.com) wrote:
: I am trying to get an SGA of about 40-45meg on my SCO box. The SCO
: system has 128Meg of ram. I upped all the kernal variables but still can
: only get about 35Meg of SGA. When I try to get more I get the following
: error message:
 

: ORA-07307: sms1sg: shmat error, unable to attach sga.
: AT&T System V/386 Error: 12: Not enough space
: Additional information: 1

I have a related question. I work with a SCO box with 64Meg of main memory and have been receiving the above error message when trying to increase the SGA size. I know I need to increase the SHMMAX and SHMNMI parameters in SCO's kernel, but what are the optimal values for these if I want a SGA of 20 Meg? What are the disadvantages to setting these values too high? (As long as I don't exceed the physical memory, that is.)

 Thanks,
  Mark Received on Thu Oct 20 1994 - 17:31:28 CET