Operating System - HP-UX
1753546 Members
5330 Online
108795 Solutions
New Discussion

Re: Global swap space is nearly full

 
SOLVED
Go to solution
Dennis Handly
Acclaimed Contributor

Re: Global swap space is nearly full

>maybe oracle not correctly configured?

 

It seems you have too much SGA space configured.

You need to get Oracle to release those shared memory segments.

0rb1t0
Advisor

Re: Global swap space is nearly full

Thank you Dennis Handly.

It seems that, as is.

Thank you very much/

0rb1t0
Advisor

Re: Global swap space is nearly full

I shutdown all oracle db and restart the hp-ux , but

 

#> swapinfo -tam
                 Mb          Mb           Mb   PCT      START/          Mb
TYPE          AVAIL        USED         FREE  USED       LIMIT     RESERVE  PRI  NAME
dev           32768           0        32768    0%           0           -    1  /dev/vg00/lvol2
reserve           -        2035        -2035
memory       130496      121065         9431   93%
total        163264      123100        40164   75%       -           0    -

i dont know, what happen (

0rb1t0
Advisor

Re: Global swap space is nearly full

#> kctune|grep -i shmm*
core_addshmem_read                           0  Default             Immed
core_addshmem_write                          0  Default             Immed
shmmax                            137256417362  137256417362        Immed
shmmni                                    7440  7440                Immed
shmseg                                    7340  7340                Immed
-----------------------------------------------
#> /usr/contrib/bin/machinfo  | grep -i Memory
Memory: 130896 MB (127.83 GB)

 

#> ipcs -m
IPC status from /dev/kmem as of Mon Jun 22 13:59:27 2015
T         ID     KEY        MODE        OWNER     GROUP
Shared Memory:
m          0 0x410c185d --rw-rw-rw-      root      root
m          1 0x4e0c0002 --rw-rw-rw-      root      root
m          2 0x410efdc8 --rw-rw-rw-      root      root
m          3 0x410c40cb --rw-r--r--      root      root
m          4 0x490ded32 --rw-r--r--      root      root
m          5 0x500c40ca --rw-r--r--      root   hpvmsys
m      32774 0x00a5c581 --rw-------     sfmdb     users
m          7 0x5e0e822b --rw-------      root      root
m          8 0x02fb07f1 --rw-------    hpsmdb     users
m          9 0x06347849 --rw-rw-rw-      root      root
m      32778 0x0c6629c9 --rw-r-----      root      root
m         11 0x010eb2ff --rw-rw-r--      root      root
m         12 0xa90c5105 -----------      root      root
m     327693 0x00000000 --rw-rw----    oracle  oinstall
m         14 0x010eb2d3 --rw-rw-r--      root      root
m         15 0x010eb278 --rw-rw-r--      root      root
m         16 0x010eb2e8 --rw-rw-r--      root      root
m      32785 0x010d8c05 --rw-rw-r--      root      root
m     426002 0x00000000 --rw-rw----    oracle  oinstall
m      98323 0x1faae8ec --rw-rw----    oracle  oinstall
m      65556 0x00003d97 --rw-------   doctest     dinst
m         21 0x00000000 D-rw-------   doctest     dinst
m         22 0x00000000 D-rw-------   doctest     dinst
m         23 0x720f0e2e --rw-------   doctest     dinst

 

Dennis Handly
Acclaimed Contributor

Re: Global swap space is nearly full

> shmmax 137256417362

 

I would say that's way too much, more than your memory.

0rb1t0
Advisor

Re: Global swap space is nearly full

i calculate this by formula:

 

127,83*1024*1024*1024=137256417362

 

sorry I dont understand, right value

Dennis Handly
Acclaimed Contributor
Solution

Re: Global swap space is nearly full

>I calculate this by formula:

 

I would cut it in half, since you can't really get a segment that big, without swapping.

0rb1t0
Advisor

Re: Global swap space is nearly full

Thank you very much  Dennis Handly