Re: 9i on hp-ux load grows to 10

From: Arkadiusz Malinowski <am_sik_at_poczta.onet.pl>
Date: Thu, 7 Nov 2002 11:03:02 +0100
Message-ID: <aqddpc$g0n$1@news.onet.pl>

I install Oracle 9i on HP-UX 11. and when application connect with him load grows to 10.
I don't jnow what to do with it.

memory 512 MB
swap 1 GB
Sometimes I get error OutOfMemmory

 kernel parameters that I changed:

# MQSeries

shmem                   1
sema                    1
semaem                  16384
semume                  256
msgmax                  4096
msgmnb                  4096
msgssz                  8
maxusers                32



#Oracle 9i

ksi_alloc_max           32768
max_thread_proc         256
maxdsiz                 1073741824
maxdsiz_64              2147483648
maxssiz                 134217728
maxssize_64bit          1073741824
maxswapchunks           16384
maxuprc                 3686
msgmap                  4098
msgmni                  4096
msgseg                  32767
msgtql                  4096
ncallout                4112
ncsize                  34
vx_ncsize               1024
nfile                   63488
nflocks                 4096
ninode                  34816
nkthread                7184
nproc                   4096
semmap                  4098
semmni                  4096
semmns                  16384
semmnu                  4092
semvmx                  32768
shmmax                  512000000 (available phys memory)
shmmni                  1024
shmseg                  1024
vps_ceiling             64


vmstat 5 5
         procs           memory                   page
faults       cpu
    r     b     w      avm    free   re   at    pi   po    fr   de    sr
in     sy    cs  us sy id
    0     2     0    38868    4334    2    0     1    0     1    0     7
113   2696   457   2  9 89
    0     2     0    39554    4289    0    0     0    0     0    0     0
109    361   281   0  0 100
    0     2     0     8198    4289    0    0     0    0     0    0     0
108    393   280   0  0 100
    0     2     0     8598    4289    0    0     0    0     0    0     0
108    365   280   0  0 100
    0     2     0    42501    4288    0    0     0    0     0    0     0

107 360 281 0 0 100 Received on Thu Nov 07 2002 - 04:03:02 CST