41 lines
1.1 KiB
SQL
41 lines
1.1 KiB
SQL
--------------------------------------------------------------------------------
|
|
--
|
|
-- File name: pvalid.sql
|
|
-- Purpose: Show valid parameter values from V$PARAMETER_VALID_VALUES
|
|
-- underlying X$ table X$KSPVLD_VALUES
|
|
--
|
|
-- Author: Tanel Poder
|
|
-- Copyright: (c) http://www.tanelpoder.com
|
|
--
|
|
-- Usage: @pvalid <param_name>
|
|
--
|
|
-- @pvalid optimizer
|
|
--
|
|
--------------------------------------------------------------------------------
|
|
|
|
COL pvalid_default HEAD DEFAULT FOR A7
|
|
COL pvalid_value HEAD VALUE FOR A30
|
|
COL pvalid_name HEAD PARAMETER FOR A50
|
|
COL pvalid_par# HEAD PAR# FOR 99999
|
|
|
|
BREAK ON pvalid_par# skip 1
|
|
|
|
PROMPT Display valid values for multioption parameters matching "&1"...
|
|
|
|
SELECT
|
|
-- INST_ID,
|
|
PARNO_KSPVLD_VALUES pvalid_par#,
|
|
NAME_KSPVLD_VALUES pvalid_name,
|
|
ORDINAL_KSPVLD_VALUES ORD,
|
|
VALUE_KSPVLD_VALUES pvalid_value,
|
|
DECODE(ISDEFAULT_KSPVLD_VALUES, 'FALSE', '', 'DEFAULT' ) pvalid_default
|
|
FROM
|
|
X$KSPVLD_VALUES
|
|
WHERE
|
|
LOWER(NAME_KSPVLD_VALUES) LIKE LOWER('%&1%')
|
|
ORDER BY
|
|
pvalid_par#,
|
|
pvalid_default,
|
|
pvalid_Value
|
|
/
|