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
