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:
Name | Data Type |
SQL_FEATURE | VARCHAR2(64) |
DEPEND_ON | VARCHAR2(64) |
CON_ID | NUMBER |
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