Re: Oracle SGA on SCO

From: Youri N. Podchosov <ynp_at_ynp.dialup.access.net>
Date: 19 Oct 1994 04:44:27 GMT
Message-ID: <38287b$2as_at_news.panix.com>

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.

+-----------------------------------------------------------------------------+

| Youri N. Podchosov (ynp) *** Davidsohn & Son, Inc. NYC *** 718-234-4140 | | Internet: ynp_at_ynp.dialup.access.net CIS: 72723,2202 AOL: ynp, yourip |

+-----------------------------------------------------------------------------+

Received on Wed Oct 19 1994 - 05:44:27 CET