Re: Oracle SGA on SCO

Youri N. Podchosov (ynp_at_ynp.dialup.access.net) wrote:
: In article <381bav$n0q_at_flood.xnet.com>, genanr_at_amiserv.xnet.com (Andrew Ryan)
: writes:
 

: |> 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 hope that someone on here might have an idea of what to do. Thanks.
: |>
: |>
: |> Andy
 

: What's your MAXUMEM limit? Low value might prevent too big shared segment
: (40-45M) from fitting into a limited virtual address space of [Oracle's]
: processes. Be sure MAXUMEM is at least 15-20 (in 4K pages). This is a
: known trap.

        This seemed to work. I had already had MAXUMEM set at 10000 but when I set it higher I was able to get more memory. I now have it at 20000 and have a SGA of 57M. I posted this so other people that might have the same problem could try it knowing it works on at least some systems. Thanks for the help.

                        Andy Received on Thu Oct 20 1994 - 04:47:28 CET