Re: 9.0.2 64-bit on redhat 3.0r2 AMD64 (4-way) 17G RAM

On 27 Aug 2004 14:25:04 -0700, wealtheow1_at_yahoo.com (Artis Gripemore) wrote:

>Please ignore this if the questions of amatuers are not allowed here.
>I thought that perhaps the rare hardware configuration might be of
>interest, however.
>
>Thanks in advance.
>
>I have shmmax set to 8G, but I cannot get db-cache_size over 2G or
>oracle runs out of memory. What have I done wrong?
>
>using--
>
>db_cache_size at just under 2G (and it cannot be increased without
>failure)
>pga_aggregate_target at 4G
>workarea_size_policy set to auto
>shared_pool_size is 24M
>shared_pool_reserved_size is 2M
>
>block size is 2048
>
>(the other settings are quite conservative, but feel free to ask)
>
>I am sure that I am doing something wrong, but I've tried a bunch of
>different sysctl.conf variations and I still get trouble increasing
>the buffers. If anyone would like to suggest a sysctl.conf
>appropriate to the hardware, or show me the error in this init.ora, I
>would appreciate it. Please ask if you need more info.
>
>Thanks again.
>
>S

Probably you are using a 32-bit version of Oracle.

On the whole this configuration is fully and utterly ridiculous. Block size should be 8k not 2k, as most Unixes have a block size of 8k.
db_cache_size is ridiculous, get it down to 256m pga_aggregate_target is ridiculous as this is a *per session* limit. 64 to 128m should be more than enough.

Shared pool should be 40M min.

All in all I would recommend you to read, and to read, and to read those manuals. You obviously heard the bell ring, but don't have a clue.

--
Sybrand Bakker, Senior Oracle DBA