Relationship of PGA_AGGREGATE_TARGET and SGA_TARGET in datawarehouse environmrnt
Hi,
I found the following in oracle 2 Day Datawarehouse DBA guide :
PGA_AGGREGATE_TARGET : The PGA_AGGREGATE_TARGET parameter is the target amount of memory that you want the total PGA across all sessions to consume. As a starting point, you
can use the following formula to define the PGA_AGGREGATE_TARGET value:
- PGA_AGGREGATE_TARGET = 3 * SGA_TARGET If you do not have enough physical memory for the PGA_AGGREGATE_TARGET to fit in memory, then reduce PGA_AGGREGATE_TARGET.
In my DW environment it is following :
PGA_AGGREGATE_TARGET=7360M
SGA_TARGET=30G
Do I need to change my settings for better performance of ETL job ?
I found the following in oracle 2 Day Datawarehouse DBA guide :
PGA_AGGREGATE_TARGET : The PGA_AGGREGATE_TARGET parameter is the target amount of memory that you want the total PGA across all sessions to consume. As a starting point, you
can use the following formula to define the PGA_AGGREGATE_TARGET value:
- PGA_AGGREGATE_TARGET = 3 * SGA_TARGET If you do not have enough physical memory for the PGA_AGGREGATE_TARGET to fit in memory, then reduce PGA_AGGREGATE_TARGET.
In my DW environment it is following :
PGA_AGGREGATE_TARGET=7360M
SGA_TARGET=30G
Do I need to change my settings for better performance of ETL job ?
0