var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: use_indirect_data_buffers oracle 8i
I'd like to make Oracle 8i use /dev/shm under linux kernel 2.4.19-pre7-ac2
with 4G RAM
Trying to use a SGA larger than 1.8G doesn't work anyway.
(ORA-27123: unable to attach to shared memory segment)
How can I make sure, that the shmfs is used?
Here my settings
tmpfs /dev/shm tmpfs size=4g 0 0
Read ( attaching SGA > 2Gb ) from here.
It might help you out to do it on your side.
Hope that helps,
Visit our Web site
... and thank you for your tip.
To lower the start address of the virtual memory is what I've already tried. I am not able to get more than 2GB for the SGA anyway ....
Here is the output of tstshm:
Number of segments gotten by shmget() = 50
Number of segments attached by shmat() = 50
Segments attach at higher addresses
Default shared memory address = 0x406a3000
Lowest shared memory address = 0x406a3000
Highest shared memory address = 0x46aa3000
Total shared memory range = 106954752
Total shared memory attached = 104857600
Largest single segment size = 2097152
Segment boundaries (SHMLBA) = 4096 (0x1000)
and ipcs -lm
------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 2097151
max total shared memory (kbytes) = 8388608
min seg size (bytes) = 1
On pages 8 of this document there is a description of how to use up to 64G of virtual memory.
That's what I tried ...