DBA Data[Home] [Help]

VIEW: SYS.V_$SQL_JOIN_FILTER

Source

View Text - Preformatted

select "QC_SESSION_ID","QC_INSTANCE_ID","SQL_PLAN_HASH_VALUE","FILTER_ID","LENGTH","BITS_SET","FILTERED","PROBED","ACTIVE","CON_ID" from v$sql_join_filter
View Text - HTML Formatted

SELECT "QC_SESSION_ID"
, "QC_INSTANCE_ID"
, "SQL_PLAN_HASH_VALUE"
, "FILTER_ID"
, "LENGTH"
, "BITS_SET"
, "FILTERED"
, "PROBED"
, "ACTIVE"
, "CON_ID"
FROM V$SQL_JOIN_FILTER