Oracle has grown by leaps and bounds. Thousand’s of new features have been added from oracle 7.3 to oracle 11g . In this course some of the parameters are also deprecated. Instead if are using obselete parameters in init.ora they don’t have any significance. Inturn Oracle has Provided a dynamic view describing which parameters are obselete parameters and whether you have used them in init.ora  or not.

Below query is used to find out whether obselete parameters are configured in init.ora

SELECT ' parameter  - '||name||' is obsolete in this version of  database!'  para
FROM   sys.v_$obsolete_parameter
WHERE   isspecified = 'TRUE'
ORDER BY  1

Below query is used to find out all the Obselete parameters in your version of Oracle database

Select  *  from sys.v_$obselete_parameter