Changed Parameters in 8i


Obsolete Parameters

A lot of parameters are obsoleted in 8i. But there is no great need to panic. If any of these are still specified in the init.ora parameter file, the instance still starts, but an error will be recorded in the alert.log

You can see the list of obsoleted parameters by querying V$OBSOLETE_PARAMETER. If you have used one of the old parameters, the ISSPECIFIED column shows TRUE.

Modified Parameters

Some parameters have been eliminated i.e. setting their value has no effect whatsoever, whereas some have been hidden along with the other _underscore parameters.

SQL> select kspponm Name, decode( KSPPOFLG,1,'Gone','Now Underscore')
  2  from x$ksppo
  3  order by 2, 1
  4  /