| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Shared_pool in relation to the kernel (Solaris)
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)
 |
 |