Note
This view is available starting with V4.2.1.
Purpose
This view displays the diagnostic information of full-link tracing.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| TYPE | VARCHAR2(16) | NO | The monitoring level of the diagnostic information. |
| TENANT_NAME | VARCHAR2(128) | NO | The tenant name. |
| MODULE_NAME | VARCHAR2(4096) | NO | The module name. |
| ACTION_NAME | VARCHAR2(4096) | NO | The action name. |
| CLIENT_IDENTIFIER | VARCHAR2(65) | NO | The client identifier name. |
| LEVEL | NUMBER(38) | NO | The full-link tracing monitoring level of the session. For example, 1 indicates diagnostic information of level 1. |
| SAMPLE_PERCENTAGE | NUMBER(38) | NO | The full-link tracing sampling frequency of the session. For example, 50 indicates that diagnostic information is sampled with a 50% probability. |
| RECORD_POLICY | VARCHAR2(32) | NO | The full-link tracing record policy of the session. The following three policies are supported:
|
Sample query
Query the diagnostic information of full-link tracing and display the first 10 records.
obclient [SYS]> SELECT * FROM SYS.GV$OB_FLT_TRACE_CONFIG WHERE ROWNUM < 10;
The query result is as follows:
+-----------+--------+-------------+-------------+-------------+-------------------+-------+-------------------+-----------------------+
| TENANT_ID | TYPE | TENANT_NAME | MODULE_NAME | ACTION_NAME | CLIENT_IDENTIFIER | LEVEL | SAMPLE_PERCENTAGE | RECORD_POLICY |
+-----------+--------+-------------+-------------+-------------+-------------------+-------+-------------------+-----------------------+
| 1004 | TENANT | oracle001 | NULL | NULL | NULL | 1 | 10 | SAMPLE_AND_SLOW_QUERY |
+-----------+--------+-------------+-------------+-------------+-------------------+-------+-------------------+-----------------------+
1 row in set (0.056 sec)