Oracle-L: Unable to obtain requested swap space

From: Jalil Zabourdine <jalilza_at_yahoo.com>
Date: Tue, 18 Jun 2002 06:43:22 -0800
Message-ID: <F001.00480431.20020618064322@fatcity.com>

Hi DBAs and GURUs,

Could you please explain me what does below message means? we got a box and it needs to be tuned.

server : Digital OSF1 V4.0 878 alpha
Oracle7 Server Release 7.3.4.0.0 with the 64-bit option

Currently Oracle shared memory segment is loaded in multiple shared memory segments and I need to setup oracle Kernal inorder to load shm segment in a single memory segment - am I right?

$ ipcs -b | grep oracle

m   13444  0x5430832 --rw-r-----    oracle      dba       784
m    9605  0x9430832 --rw-r-----    oracle      dba   4194304
m    9606  0xd430832 --rw-r-----    oracle      dba   4194304
m    9607 0x11430832 --rw-r-----    oracle      dba    212992

Note : there is only one instance on this box.

$ tstshm

swap space below 10 percent free
Unable to obtain requested swap space
Unable to obtain requested swap space
...
Unable to obtain requested swap space
Unable to obtain requested swap space
Number of segments gotten by shmget() = 17 Number of segments attached by shmat() = 17 Odd-sized segments are rounded up to even size Segments attach at higher addresses
Maximum size segments are not attached contiguously! Segment separation = 4194304 bytes

Default shared memory address = 0x1e000
Lowest shared memory address  = 0x1e000
Highest shared memory address = 0x11fc1e000
Total shared memory range     = 4831838208 (0x120000000)
Total shared memory attached  = 71303151 (0x43fffef)
Largest single segment size   =  4194304 (0x400000)
Segment boundaries (SHMLBA)   =     8192 (0x2000)

Thanks in advance for your help!

Regards,
-Jalil

Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jalil Zabourdine
  INET: jalilza_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jun 18 2002 - 09:43:22 CDT