Re: Tuning

> What are Oracle and EnterpriseDB recommending for shmmax these days?

According to Oracle "set to a value half the size of physical memory".
[http://www.oracle.com/technology/tech/linux/validated-configurations/ht
ml/vc_dell6850-rhel4-cx500-1_1.html]

I've been talking to an Oracle DBA and he said that they are setting
this to something between 70-80% on a dedicated database server. As long
as one doesn't run other heavy processes and leave room for the OS.

EnterpriseDB advocates: 250 KB + 8.2 KB * shared_buffers + 14.2 kB *
max_connections up to infinity
[http://www.enterprisedb.com/documentation/kernel-resources.html]


// John