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