V$PARAMETER_VALID_VALUES

The view reports the valid values allowed for list parameters.

In Oracle 12.1.0.2 V$PARAMETER_VALID_VALUES has the following columns:

NameData TypeComments
NUMNUMBER
NAMEVARCHAR2(64)
ORDINALNUMBER
VALUEVARCHAR2(255)
ISDEFAULTVARCHAR2(64)
CON_IDNUMBERContainer ID - new in 12.1

ORDINAL is the number of the value for the specific parameter, starting at 1

The following table shows the number of supported and unsupported list parameters for various Oracle releases:

Version Supported Unsupported Total
11.2.0.3 72 87 159
11.2.0.4 73 91 164
12.1.0.1 75 112 187
12.1.0.2 78 124 202

V$PARAMETER_VALID_VALUES is based on X$KSPVLD_VALUES

V$PARAMETER_VALID_VALUES does not report valid values for unsupported parameters.

However X$KSPVLD_VALUES reports valid values for all parameters including unsupported parameters

For example to list valid values for the "_serial_direct_read" unsupported parameter use:

SELECT  
  ordinal_kspvld_values   AS "Ordinal",
  value_kspvld_values     AS "Value",
  isdefault_kspvld_values AS "Is Default"
FROM x$kspvld_values
WHERE name_kspvld_values = '_serial_direct_read'
ORDER BY ordinal_kspvld_values;

In Oracle 12.1.0.2, the above query returns the following results

OrdinalValueIs Default
1ALWAYSFALSE
2AUTOFALSE
3NEVERFALSE
4FALSEFALSE
5TRUEFALSE

Note that no default value is reported for "serial_direct_reads".