11.2.0.3 : Many hidden parameters in init.ora
Hi ,
Is it normal to have all these hidden parameters in init.ora ?
and can these parameters generate a performance issue ?
Best regards.
GD
System Parameters with Non-Default or Modified Values
Collected from GV$SYSTEM_PARAMETER2 where isdefault = 'FALSE' OR ismodified != 'FALSE'. "Is Default" = FALSE means the parameter was set in the spfile.
| # | Name | Inst | Ord | Is Default | Is Modified | Value | Display Value | Description |
|---|---|---|---|---|---|---|---|---|
| 1 | _aggregation_optimization_settings | 1 | 1 | FALSE | FALSE | 0 | settings for aggregation optimizations | |
| 2 | _always_anti_join | 1 | 1 | FALSE | FALSE | CHOOSE | always use this method for anti-join when possible | |
| 3 | _always_semi_join | 1 | 1 | FALSE | FALSE | CHOOSE | always use this method for semi-join when possible |
5