Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    8

    Unanswered: use_indirect_data_buffers oracle 8i

    Hi all,





    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




    fstab:

    tmpfs /dev/shm tmpfs size=4g 0 0




    init.ora:

    use_indirect_data_buffers=true





    Thank you

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    Read ( attaching SGA > 2Gb ) from here.

    It might help you out to do it on your side.

    Hope that helps,

    clio_usa
    OCP DBA
    Visit our Web site
    .
    .
    .

  3. #3
    Join Date
    Jul 2002
    Posts
    8
    Hello,

    ... 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 ...

    http://otn.oracle.com/tech/linux/pdf...2_accepted.pdf

    bye, Klaus

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •