V$SQL_FEATURE_DEPENDENCY

V$SQL_FEATURE_DEPENDENCY reports dependecies between features included in the kernel.

V$SQL_FEATURE_DEPENDENCY is based on X$KQSFMDEP

This dynamic performance view does not appear to have been fully implemented in Oracle 12.1.0.2 and below.

In Oracle 12.1.0.2 V$SQL_FEATURE_DEPENDENCY has the following columns:

NameData Type
SQL_FEATUREVARCHAR2(64)
DEPEND_ONVARCHAR2(64)
CON_IDNUMBER

SQL_FEATURE is the name of the feature

DEPEND_ON is the name of the feature on which SQL_FEATURE is dependent

In Oracle 12.1.0.2 only one feature has a dependency. This is QKSFM_OR_EXPAND which is dependent on QKSFM_JPPD.

In Oracle 12.1.0.2 DEPEND_ON is NONE for all remaining rows in the view