Oracle SGA Size over 1gb

From: <Mark_Greenhalgh_at_idx.com>
Date: Thu, 30 Apr 1998 13:50:37 -0400

To: alpha-osf-managers

Hi all,

     I'm running Oracle 7.3.4 on a Digital Unix system v4.0d. For the
last couple of days I have been trying to extend my SGA past 1gb and have
been unsuccessful. As soon as I go over 1gb the Oracle instance fails to
start with the following error:
SVRMGR> startup
Internal AIO consistency error: Cannot initialize aio library.
        Error 35: Operation would block
        Aborting...

The instance then creates trace file and core dumps. This problem seems
to have Oracle stumped. I assume other people have been able to go past
this 1gb limit that I'm hitting..

The parameters that I have modified so far are:
vm:
     vm-maxvas = 4294967296
     vm-mapentries=16384
     vm-vpagemax=262144
     vm-ubcseqstartpercent=10
     new-wire-method = 0
     ubc-minpercent = 1
     ubc-maxpercent = 2
ipc:
     shm-max = 2118123520
     shm-seg = 32
     msg-max = 8192
     msg-mnb = 16384
     msg-mni = 1024
     msg-tql = 4096
     sem-aem = 16384
     sem-mni = 200
     num-of-sems = 200
     sem-msl = 200
     sem-opm = 200
     sem-ume = 200
     sem-vmx = 32767
     ssm-threshold=0
dlm:
     dlm_disable_grptx = 0
proc:
     max-proc-per-user = 1024
     max-threads-per-user = 1024
     max-per-proc-data-size = 2147483648
     max-per-proc-address-space =2147483648
     enhanced-core-name = 1
     enhanced-core-max-versions= 4
vfs:
     name-cache-hash-size=512
advfs:
        AdvfsCacheMaxPercent=8
     AdvfsMaxDevQLen=16
inet:
        tcbhashsize=56
rt:
     aio-max-num = 512
     aio-max-percent = 2



Thanks,

Mark Greenhalgh
IDX Systems Corporation
mark_greenhalgh_at_idx.com
Received on Thu Apr 30 1998 - 19:55:44 NZST

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:37 NZDT