GV$SQL_JOIN_FILTER definition in Oracle Database 11.2
GV$SQL_JOIN_FILTER

SELECT
  INST_ID,                                 -- INST_ID NUMBER
  QCSID,                                   -- QC_SESSION_ID NUMBER
  QCINSTID,                                -- QC_INSTANCE_ID NUMBER
  SQLHASHV,                                -- SQL_PLAN_HASH_VALUE NUMBER
  LEN,                                     -- LENGTH NUMBER
  NSET,                                    -- BITS_SET NUMBER
  FLT,                                     -- FILTERED NUMBER
  TOT,                                     -- PROBED NUMBER
  ACTIVE                                   -- ACTIVE NUMBER
FROM
  X$QESBLSTAT
WHERE
  QCINSTID != 0

home |  up