Oracle Database Discussions

Hi, i have the following configuration

* RedHat Enterprise Linux (RHEL) 4.0 - SMP Kernel
* Linux x86
* Oracle 10g R2
* Physical memory 32GB

This is the current DB configuration
* SGA_TARGET 2GB
* PGA 500M

This is the required db configuration
* Buffer cache (3.5GB)
* PGA (2GB)

this is the parameters i set to configure VLM with ramfs (w/o the details)
db_block_buffers=458752
db_block_size=8192
shared_pool_size=800m
java_pool_size=32m
large_pool_size=32m
use_indirect_data_buffers=true
*remove sga_target

semmsl = 250
semmns = 32000
semopm = 100
semmni = 128
shmmni = 4096
shmall = 2097152
shmmax = 4294967294
soft memlock 3145728
hard memlock 3145728

ulimit -a output
core file size 0
data seg size unlimited
file size unlimited
pending signals 1024
max locked memory 32
max memory size unlimited
open files 65536
pipe size 8
POSIX message queues 819200
stack size 10240
cpu time unlimited
max user processes 16384
virtual memory unlimited
file locks unlimited

I've followed the note 317141.1 to configure the VLM. DB started with no error, however after 2-3 hours, DBWR hit with ORA-04030 (dbw0 trace file in alert log) and terminating the instance. Subsequent trying to bring up the instance failed with out of memory, i think this is due to the shared memory is not released after instance crashed.

What's went wrong? Please enlighten me. thank you.

Edited by: Kok Aik on May 24, 2009 3:44 PM

Edited by: Kok Aik on May 24, 2009 4:32 PM (added ulimit, add remove sga_target)

Edited by: Kok Aik on May 24, 2009 4:41 PM (added more kernel parameter)