The view reports the valid values allowed for list parameters.
In Oracle 12.1.0.2 V$PARAMETER_VALID_VALUES has the following columns:
Name | Data Type | Comments |
NUM | NUMBER | |
NAME | VARCHAR2(64) | |
ORDINAL | NUMBER | |
VALUE | VARCHAR2(255) | |
ISDEFAULT | VARCHAR2(64) | |
CON_ID | NUMBER | Container 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
Ordinal | Value | Is Default |
1 | ALWAYS | FALSE |
2 | AUTO | FALSE |
3 | NEVER | FALSE |
4 | FALSE | FALSE |
5 | TRUE | FALSE |
Note that no default value is reported for "serial_direct_reads".