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 before a join operation in order to avoid parallel communication.)
QC (Query Coordinator) session ID of the given cursor for the given parallel query
QC (Query Coordinator) instance ID of the given cursor for the given parallel query
SQL plan hash value of the given cursor for the given parallel query
An ID that identifies the join filter in the given cursor and corresponds to the filter ID in the execution plan
Total size of the join filter field
Number of bits set in this filter
Number of rows seen by the join filter
Number of rows of the right table that have been tested against the bitmap filter. This is the sum of the filtered rows plus the non-filtered rows.
Whether the filter is active (Yes) or not (No)
The ID of the container to which the data pertains. Possible values include:
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data