ALL INIT.ORA PARAMETER NOTES:
  • Parameter - Name of the undocumented parameter
  • Desc - Brief description of parameter
  • Value - Current value for the parameter
  • Default? - Is this the default value. FALSE indicates the value has been changed in the init.ora.

  • Some of these default values parameters are derived from others. They have KSPPSTDF = FALSE because the parameters on which they are based are not defaulting. Note also that there is some non-trivial operating system dependency (read inconsistency) here, particularly with the cpu_count derived parameters.
  • Always double check your init.ora to determine if the value has actually been changed.