Hi all,
I am trying to configure a DBCA template to perform silent database creations on servers at our client sites. The amount of RAM could vary from server to server. For this reason, I am specifying the following parameters:
customSGA=false
percentageMemTOSGA=70
In principle, this works pretty well - my DB is created with a suitable value for SGA_TARGET based on the RAM available on the server. However, the value that it uses for PGA_AGGREGATE_TARGET is too small for our needs. From experience, we can get by with a smaller SGA, but we need a relatively large PGA.
I have tried specifying the parameter "pga_aggregate_target" in the template (and thus trying to "override" the decision of DBCA) but DBCA ignores my "hard-coded" value for this and sets pga_aggregate_target according to (presumably) some calculation based on:
- The amount of RAM available
- The value of "percentageMemTOSGA"
- Some "other" value which tells DBCA how to divide up the %age memory it will take between SGA and PGA
So, my question is:
Does anybody know how to effectively use both "percentageMemTOSGA",
and:
EITHER:
* tell DBCA how to split the memory that it will use from RAM (in this case 70%) between pga_aggregate_target and sga_target (some parameter maybe like "percent_to_pga" and "percent_to_sga")
OR (not as useful but better than no control):
* specify explicitly a value (or percentage) for pga_aggregate_target, but leave the value of sga_target to be decided based on the percentageMemTOSGA
?
I hope I've explained that well enough...
Regards,
Ados