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
