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')