Note
This view is available starting with V4.2.0.
Purpose
This view dynamically displays information about the execution of Join Filters on the current OBServer node for the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| QC_SESSION_ID | NUMBER | NO | The Query Coordinator (QC) session ID for the cursor of the parallel query. For V4.2.x:
|
| QC_INSTANCE_ID | NUMBER | NO | The Query Coordinator (QC) instance ID for the cursor of the parallel query. |
| SQL_PLAN_HASH_VALUE | NUMBER | NO | The hash value of the SQL plan for the cursor of the parallel query. |
| FILTER_ID | NUMBER | NO | The ID of the join filter in the cursor, which corresponds to the filter ID in the execution plan. |
| BITS_SET | NUMBER | NO | The size of the bitmap (join bitmap) used in the BLOOM_FILTER. This field is only used for compatibility in the current version. |
| FILTERED | NUMBER | NO | The number of rows processed by the join filter. |
| PROBED | NUMBER | NO | The total number of rows in the right table that have passed the bitmap filter test, including both filtered and unfiltered rows. |
| ACTIVE | NUMBER | NO | Indicates whether the filter is active (1) or inactive (0). |
| CON_ID | NUMBER | NO | The ID of the container to which the data belongs. |
| TRACE_ID | CHAR(64) | NO | The trace ID corresponding to the SQL statement. |
Sample query
In the user tenant, query the information about the execution of join filters on the current node.
obclient [SYS]> SELECT * FROM SYS.V$SQL_JOIN_FILTER;
The query result is as follows:
+----------------+----------+---------------+----------------+---------------------+-----------+----------+----------+--------+--------+--------+------------------------------------------------------------------+
| SVR_IP | SVR_PORT | QC_SESSION_ID | QC_INSTANCE_ID | SQL_PLAN_HASH_VALUE | FILTER_ID | BITS_SET | FILTERED | PROBED | ACTIVE | CON_ID | TRACE_ID |
+----------------+----------+---------------+----------------+---------------------+-----------+----------+----------+--------+--------+--------+------------------------------------------------------------------+
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 2509 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 2530 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 2504 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 0 | NULL | 1004 | y70***************************-0-0 |
| 11.xxx.xxx.xxx | 28825 | NULL | NULL | NULL | 0 | NULL | 0 | 2457 | NULL | 1004 | y70***************************-0-0 |
+----------------+----------+---------------+----------------+---------------------+-----------+----------+----------+--------+--------+--------+------------------------------------------------------------------+
8 rows in set