Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Shared_pool in relation to the kernel (Solaris)

Shared_pool in relation to the kernel (Solaris)

From: <Jaouich.Cyril_at_hydro.qc.ca>
Date: Mon, 20 Aug 2001 08:44:47 -0700
Message-ID: <F001.00371017.20010820083128@fatcity.com>

Hi all,

        I've got a question related to the SHARED_POOL_SIZE parameter in my init file. Currently our kernel is defined with a 256MB of shared_memory (set shmsys:shminfo_shmmax=268435456) and we have 2 databases running on this server, the first one has 9Mbytes of shared memory and the other 52Mbytes.

        When I do an ipcs -mb, I see:

IPC status from <running system> as of Mon Aug 20 11:21:07 2001 T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP NATTCH      SEGSZ Shared Memory:

m          0   0x50000951 --rw-r--r--     root     root     root     root      1         68
m       8705   0x0a3656bf --rw-r-----   oracle      dba   oracle      dba     19  126025728
m       2050   0x93911bec --rw-r-----   oracle      dba   oracle      dba     10  120774656
m          3   0x77c0ffee --rw-------     root     root     root     root      3     180584


        My questions are:

1- How come I see both of my Oracle using much more then what is defined in the init.ora file?

2- How can I determine how big the kernel shared_memory should be, in relation to my Oracle shared_pool configuration? (I ask this question because I need to increase the shared_pool in one of my database to increase the buffer cache hit ratio)

       
        Thanks to all who will reply :)

Cyril Jaouich (Conseiller Unix)



Centre de support informatique CSI

Tél 514-289-1122 x6237 Received on Mon Aug 20 2001 - 10:44:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US