V$SQL_JOIN_FILTER displays performance information about the characteristics of join filters when they are used for a parallel cursor. (A join filter is a bitmap filter applied to table rows prior to a join operation in order to avoid parallel communication.)
| Column | Datatype | Description |
|---|---|---|
QC_SESSION_ID |
NUMBER |
QC (Query Coordinator) session ID of the given cursor for the given parallel query |
QC_INSTANCE_ID |
NUMBER |
QC (Query Coordinator) instance ID of the given cursor for the given parallel query |
SQL_PLAN_HASH_VALUE |
NUMBER |
SQL plan hash value of the given cursor for the given parallel query |
LENGTH |
NUMBER |
Total size of the join filter field |
BITS_SET |
NUMBER |
Number of bits set in this filter |
FILTERED |
NUMBER |
Number of rows seen by the join filter |
PROBED |
NUMBER |
Number of rows of the right table that have be tested against the bitmap filter. This is the sum of the filtered rows plus the non-filtered rows. |
ACTIVE |
NUMBER |
Whether the filter is active (Yes) or not (No) |