Oracle Parameter Valid Values Viewer
Lists all valid values for a specified Oracle initialization parameter. Useful for validating configuration options before modifying database parameters.
oraclesqlmaintenance-cleanupv1.0.0
0 stars0 downloads16 views0 comments
By OracleDba • Created
Code
(17 lines)1234567891011121314151617
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/param_valid_values.sql
-- Author : Tim Hall
-- Description : Lists all valid values for the specified parameter.
-- Call Syntax : @param_valid_values (parameter-name)
-- Requirements : Access to the v$views.
-- Last Modified: 14/05/2013
-- -----------------------------------------------------------------------------------
SET VERIFY OFF
COLUMN value FORMAT A50
COLUMN isdefault FORMAT A10
SELECT value,
isdefault
FROM v$parameter_valid_values
WHERE name = '&1';