Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

size of Kernel parameter and SGA

536473Oct 13 2006 — edited Oct 24 2006

Hi,

Can you please suggest me the ideal size of kernel parameters and SGA?

Currently, I have installed 2GB RAM on my machine using Oracle 10.1 database version on Fedora Linux platform. The parameters are currently set as below:

kernel.shmall = 2097152 (2MB)
kernel.shmmax = 2147483648 (2048 MB)
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128

I will appreciate if you can give me an idea about the proper size of SGA including SHARED_POOL_SIZE,LARGE_POOL_SIZE AND JAVA_POOL_SIZE.

Thanks in advance.

Jayesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2006

Added on Oct 13 2006

#general-database-discussions

7 comments

1,184 views