Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$SQL_JOIN_FILTER

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

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
FILTER_ID NUMBER An ID that identifies the join filter in the given cursor and corresponds to the filter ID in the execution plan
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 been 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)
CON_ID NUMBER 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