ashish 1901 wrote:You are leaving only 1G for PGA. That is too low for any data warehouse I've worked on recently. Look at the DBA_%_ADVICE views, you are probably allocating for more SGA than is needed.
We are having datawarehouse of size 200gb.and our server configuration are 24GB RAM and 1TB disk space..Now my question is i've set
will it impact the database perormance in negetive way???plz suggest
ashish 1901 wrote:I didn't calculate it - you did. Look at your settings for memory_target and sga_target and all will become clear.
how you have calculated 1g for PGA???