V$PARAMETER

The view reports the values of all supported parameters. It also reports any unsupported parameters with non-default values

In Oracle 12.1.0.2 V$PARAMETER has the following columns:

TYPE can be:

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

Note that the above figures may vary slightly due to platform and patchset differences

V$PARAMETER does not report default values for unsupported parameters.

X$KSPPI reports values for all parameters including unsupported parameters

To dump values for all parameters use:

SELECT i.ksppinm||';'||sv.ksppstvl
FROM x$ksppi i, x$ksppsv sv
WHERE i.indx = sv.indx
ORDER BY i.ksppinm;

To set an unsupported parameter specify double quotees around the name. For example:

ALTER SESSION SET "_serial_direct_read" = NEVER;