Re: Oracle Shared Memory Problem (DEC UNIX 4.0)

Peter Bruhn wrote:
>
> Hello!
>
> I am having big trouble with shared memory for oracle. It is oracle 7.3.2
> on a DEC-Alpha (DU 4.0).
>
> > uname -a
> OSF1 miss.wu-wien.ac.at V4.0 564 alpha alpha
>
> When trying to start oracle I get
>
> ORA-07307: sms1sg: shmat error, unable to attach sga.
> DEC OSF/1 (AXP) Error: 12: Not enough space
> Additional information: 1
>
> > sysconfig -q ipc
> ipc:
> msg-max = 8192
> msg-mnb = 16384
> msg-mni = 64
> msg-tql = 40
> shm-max = 67108864
> shm-min = 1
> shm-mni = 128
> shm-seg = 32
> sem-mni = 2048
> sem-msl = 25
> sem-opm = 10
> sem-ume = 10
> sem-vmx = 32767
> sem-aem = 16384
> num-of-sems = 60
> max-kernel-ports = 93911
> port-hash-max-num = 4695550
> port-reserved-max-num = 93911
> set-max-num = 24837
> ssm-threshold = 8388608
> ssm-enable-core-dump = 1
>
> So the maximum size of a shared memory segment should be 67108864 byte.
>
> > pwd
> /usr/oracle/app/oracle/product/7.3.2
>
> > bin/tstshm
> Number of segments gotten by shmget() = 50
> Number of segments attached by shmat() = 31
> Odd-sized segments are rounded up to even size
> Segments attach at higher addresses
> Default shared memory address = 0x10000
> Lowest shared memory address = 0x10000
> Highest shared memory address = 0x11fc10000
> Total shared memory range = 4831838208 (0x120000000)
> Total shared memory attached = 134217696 (0x7ffffe0)
> Largest single segment size = 4194304 (0x400000)
> Segment boundaries (SHMLBA) = 8192 (0x2000)
>
> This seems to say that the maximum size of a shared memory segment is
> 4194304 byte.
>
> I guess the problem is that the maximum size of segment ist too low, but
> how can I change this, the operating system seem to say it is much larger.
>
> Or is there something else that I am missing?
>
> Thanks for any help is highly appreciated,
> Peter

I'm not 100% sure on this but I believe the Oracle utility, tstshm, uses the default segment size to test allocation of memory. I get the same results with tstshm on Oracle 7.2.2 and DU 3.2C. However, when I look at the shared memory with 'ipcs -m -a', it shows a much larger single block of memory allocated by Oracle.

Bill Received on Fri Nov 21 1997 - 00:00:00 CST