SELECT
  qc_session_id,                           -- QC_SESSION_ID NUMBER
  qc_instance_id,                          -- QC_INSTANCE_ID NUMBER
  sql_plan_hash_value,                     -- SQL_PLAN_HASH_VALUE NUMBER
  length,                                  -- LENGTH NUMBER
  bits_set,                                -- BITS_SET NUMBER
  filtered,                                -- FILTERED NUMBER
  probed,                                  -- PROBED NUMBER
  active                                   -- ACTIVE NUMBER
FROM
  GV$SQL_JOIN_FILTER
WHERE
  inst_id = USERENV('INSTANCE')