V$SQL_FEATURE_HIERARCHY

V$SQL_FEATURE_HIERARCHY reports the hierarchical relationship between features.

V$SQL_FEATURE_HIERARCHY is based on X$KQSFMPRT

In Oracle 12.1.0.2 V$SQL_FEATURE_HIERARCHY has the following columns:

NameData Type
SQL_FEATUREVARCHAR2(64)
PARENT_IDVARCHAR2(64)
CON_IDNUMBER

SQL_FEATURE is the name of the feature

PARENT_ID is the name of the parent feature

The root of the hierarchy is QKSFM_ALL

The following query prints the hierarchy in a nested format:

SELECT lpad (' ',level * 2,' ') || sql_feature
FROM v$sql_feature_hierarchy
CONECT BY PRIOR sql_feature = parent_id
START WITH parent_id = 'QKSFM_ALL'

For example:

...
QKSFM_TRANSFORMATION
  QKSFM_CBQT
    QKSFM_CVM
    QKSFM_DIST_PLCMT
    QKSFM_JOINFAC
    QKSFM_JPPD
    QKSFM_PLACE_GROUP_BY
    QKSFM_PULL_PRED
...