ORA-04030 with PGA_AGGREGATE_TARGET
Date: 10 Sep 2003 00:22:22 -0700
Message-ID: <4a1c57c2.0309092322.59677fcc_at_posting.google.com>
Hello ,
Oracle 9i (9.0.1.0.0) on HP-UX 11.11
Physical RAM : 2GB
Oracle init.ora parameters :
DB_BLOCK_SIZE=4096
DB_CACHE_SZIE=314572800
LOG_BUFFER 10M
JAVA_POOL 30M
LARGE_POOL 1M
SHARED_POOL 250M
With these parameters constant , I set
WORKAREA_SIZE_POLICY=AUTO
PGA_AGGREGATE_TARGET=157286400 (Calculation is (RAM*0.8)*0.2 for OLTP
Systems from Oracle Manuals )
Woth these settings I get memory errors ORA-04030
If I set
WORKAREA_SIZE_POLICY=MANUAL & set SORT_AREA_SIZE=10M , obviously I do
not Memory errors.
My question ,
What should be reasonable value for PGA_AGGREGATE_TARGET to avoid memory errors ?
Also I would like to know if there is any heavy load if I turn on Multimaster Replication ?
Thanks & Regards,
Mahesh Hardikar
Received on Wed Sep 10 2003 - 09:22:22 CEST