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