Views

This section discusses views that contain useful diagnostic information

Dynamic Performance Views
V$DIAG_INFO
V$PARAMETER
V$PARAMETER_VALID_VALUES
V$SQL_FEATURE
V$SQL_FEATURE_DEPENDENCY
V$SQL_FEATURE_HIERARCHY
V$SQL_HINT
 
Data Dictionary Views
DBA_HIST_PLAN_OPERATION_NAME
DBA_HIST_PLAN_OPTION_NAME
DBA_HIST_TOPLEVELCALL_NAME