Overview
Displays diagnostic information for end-to-end tracing.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID:
|
| TYPE | varchar(16) | NO | The monitoring level of diagnostic information:
|
| TENANT_NAME | varchar(128) | NO | Tenant Name |
| MODULE_NAME | varchar(4096) | NO | Module Name |
| ACTION_NAME | varchar(4096) | NO | Action |
| CLIENT_IDENTIFIER | varchar(65) | NO | Client Identifier |
| LEVEL | bigint(20) | NO | Indicates the end-to-end tracing monitoring level for the session. For example, 1 indicates diagnostic information at level 1. |
| SAMPLE_PERCENTAGE | bigint(20) | NO | Indicates the sampling frequency for end-to-end tracing of the session. For example, 50 means diagnostic information is sampled with a probability of 50%. |
| RECORD_POLICY | varchar(32) | NO | Specifies the trace recording strategy for the entire session. The following three strategies are supported:
|
Sample query
View the diagnostic information of end-to-end tracing, displaying the first 10 records.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_FLT_TRACE_CONFIG LIMIT 10;
The query result is as follows:
+-----------+--------+-------------+-------------+-------------+-------------------+-------+-------------------+-----------------------+
| TENANT_ID | TYPE | TENANT_NAME | MODULE_NAME | ACTION_NAME | CLIENT_IDENTIFIER | LEVEL | SAMPLE_PERCENTAGE | RECORD_POLICY |
+-----------+--------+-------------+-------------+-------------+-------------------+-------+-------------------+-----------------------+
| 1 | TENANT | sys | | | | 1 | 10 | SAMPLE_AND_SLOW_QUERY |
| 1001 | TENANT | META$1002 | | | | 1 | 10 | SAMPLE_AND_SLOW_QUERY |
| 1002 | TENANT | mysql001 | | | | 1 | 10 | SAMPLE_AND_SLOW_QUERY |
| 1003 | TENANT | META$1004 | | | | 1 | 10 | SAMPLE_AND_SLOW_QUERY |
| 1004 | TENANT | oracle001 | | | | 1 | 10 | SAMPLE_AND_SLOW_QUERY |
+-----------+--------+-------------+-------------+-------------+-------------------+-------+-------------------+-----------------------+
5 rows in set (0.035 sec)