Friday, October 31, 2008

Init.ora Data Dictionary Views

he following Data Dictionary Views provides complete list of init.ora file parameters currently set /used in the databases. for all RAC environments query gv$parameter, gv$parameter2, gv$spparameter other environments query  v$parameter ,v$parameter2, v$spparameter

 

List of currently supported parameters can be vies using the following query

 

SELECT name, value
FROM gv$parameter
ORDER BY 1;

 

I strongly recommend to use GV$ views to view all data dictionary data in NON-RAC Environment also, because when you start working on RAC environment you do not have to learn or query a different views.

 

List of all parameters those you can modify using alter system command

 

SELECT name, value
FROM gv$parameter
WHERE isdefault = 'FALSE'
ORDER BY 1;

 

List of obsolete parameters in any environment can be found using

 

SELECT *  FROM gv$obsolete_parameter  ORDER BY 1;

 

You can also use v$spparameter data dictionary view for complete list of parameters set by SPFILE and PFILE

0 comments: