Shared Memory and Semaphores

From: peter <hhh.database_at_gmail.com>
Date: 9 Apr 2007 22:03:55 -0700
Message-ID: <1176181435.757447.243310@y66g2000hsf.googlegroups.com>

I have doubt in both of these.
Don't you think oracle is taking to much shared memory and semaphores are on these server.
It's a test server, there so many databases are here on it. Please provide any link, which can help me to find that how much shared memory and semaphores are good for current databases.

ipcs -bA

IPC status from <running system> as of Tue Apr 10 00:57:03 EDT 200 T ID KEY MODE OWNER GROUP QBYTES Message Queues:
T ID KEY MODE OWNER GROUP SEGSZ Shared Memory:

m          0   0x50000b51 --rw-r--r--     root     root          4
m          2   0xcace     --rw-rw-rw-     root    other          2
m          4   0x794806c9 --rw-rw-rw-    iscan    iscan        404
m        605   0x7b736a3c --rw-r-----   oracle      dba  469762048
m        606   0x8de14854 --rw-r-----   oracle      dba  469762048
m        607   0x7b93204  --rw-r-----   oracle      dba  469762048
m        608   0xad4f2694 --rw-r-----   oracle      dba  469762048
m        609   0x8aa27afc --rw-r-----   oracle      dba  352321536
m        610   0x4162ad10 --rw-r-----   oracle      dba   62914560
m        611   0x9f90b658 --rw-r-----   oracle      dba  725614592
m        612   0x459b08f4 --rw-r-----   oracle      dba  725614592
m       1813   0x63c8774  --rw-r-----   oracle      dba  624951296
m        614   0x7ffd92b4 --rw-r-----   oracle      dba  109051904
m       1815   0x5db01f24 --rw-r-----   oracle      dba  624951296
m       1816   0x7f7048f4 --rw-r-----   oracle      dba  557842432
m        617   0x753be250 --rw-r-----   oracle      dba  608174080
m        618   0xf7604d08 --rw-r-----   oracle      dba  624951296
m        619   0xea7b9830 --rw-r-----   oracle      dba  608174080
m        620   0xe742130c --rw-r-----   oracle      dba  125829120
m        621   0x77e1ae64 --rw-r-----   oracle      dba  125829120
m        622   0xd87a6d68 --rw-r-----   oracle      dba  809500672
m        623   0x2b7f7890 --rw-r-----   oracle      dba  629145600
m         24   0x52edca4c --rw-r-----   oracle      dba   70328320
m        625   0x5e10277c --rw-r-----   oracle      dba  457179136
m        626   0xad93f260 --rw-r-----   oracle      dba   92274688
m        627   0x38f9dd8  --rw-r-----   oracle      dba   92274688
m         28   0x435dce61 --rw-rw-rw-     root     root          4
m         29   0x435dce60 --rw-rw-rw-     root     root       8024
m       3030   0x6a3b1b6c --rw-rw----   oracle      dba  457179136
m        631   0x385f5f14 --rw-rw----   oracle      dba  503316480
T         ID      KEY        MODE        OWNER    GROUP NSEMS
Semaphores:
s          0   0x4900530e --ra-ra-ra-     root    other     1
s          1   0x49005404 --ra-ra-ra-     root    other     3
s          4   0x450005f7 --ra-ra-ra-     root    other     1
s          5   0xcace     --ra-ra-ra-     root    other     1
s          6   0x45000607 --ra-ra-ra-     root    other     1
s         10   0x794806c9 --ra-ra-ra-    iscan    iscan     1
s     196619   0xe04ec970 --ra-r-----   oracle      dba   504
s     196620   0x669b63bc --ra-r-----   oracle      dba   504
s     196621   0x60c04c54 --ra-r-----   oracle      dba   504
s     196622   0x11d80288 --ra-r-----   oracle      dba   504
s     196623   0xb731cc50 --ra-r-----   oracle      dba  1004
s     196624   0x52a9bc04 --ra-r-----   oracle      dba   204
s     196625   0xd29f68f0 --ra-r-----   oracle      dba   304
s     196626   0x847a57e8 --ra-r-----   oracle      dba   304
s     589843   0x1ab1cd94 --ra-r-----   oracle      dba   204
s     196628   0x6905cd64 --ra-r-----   oracle      dba   104
s     589845   0x4a126bbc --ra-r-----   oracle      dba   204
s     655382   0x6b3ab274 --ra-r-----   oracle      dba   204
s     196631   0xbe97696c --ra-r-----   oracle      dba   104
s     196632   0xa503480  --ra-r-----   oracle      dba   204
s     196633   0xabbfc32c --ra-r-----   oracle      dba   104
s     262170   0x4c242c04 --ra-r-----   oracle      dba   154
s     196635   0xf4e03bb0 --ra-r-----   oracle      dba   154
s     196636   0x1c8ed194 --ra-r-----   oracle      dba   204
s     196637   0xfcbbea2c --ra-r-----   oracle      dba   304
s     196638   0xd08959a0 --ra-r-----   oracle      dba    24
s     196639   0x7dce3140 --ra-r-----   oracle      dba    54
s     196640   0xe30ff294 --ra-r-----   oracle      dba    54
s     196641   0x62465dc4 --ra-r-----   oracle      dba    54
s    7536674   0xeea76d4  --ra-ra----   oracle      dba  1002
s    1703971   0xeea76d5  --ra-ra----   oracle      dba  1002
s         36   0xeea76d6  --ra-ra----   oracle      dba  1002
s     196645   0xdd613dbc --ra-ra----   oracle      dba  1002
s         38   0xdd613dbd --ra-ra----   oracle      dba  1002
s         39   0xdd613dbe --ra-ra----   oracle      dba  1002

Received on Tue Apr 10 2007 - 00:03:55 CDT