Why is the line with "pga_aggregate_target" missing from the Health check report under "Default Initialization Parameters"?
Database | Diagnose | Health Check -- run the report and have various sections enabled, specifically, "Default Initialization Parameters"?
The Health Check report of one server, compared to another server (which are suppose to be the same) show differences in the parameters listed. But both should have the same intialization parameters set. the parameter is correctly listed when looking up Oracle Parameters.
The Health Check will list only the initialization parameters that are specifically noted as "default"
To verify, run:
select * from v$parameter order by name
In the results, look for "pga_aggregate_target". Is the ISDEFAULT column set to true for this field? If not, Toad will not display it. The Health check list is not necessarily a full list of Oracle parameters, just a list of those noted as default, in this particular section "Default Initialization Parameters".
