Syntax
DECODE_TRACE_ID()
Purpose
The DECODE_TRACE_ID() function is used to parse the trace_id and return the IP address and port of the SQL request source server. You can also view the related information in the GV$OB_SQL_AUDIT view.
Examples
obclient [(none)]> SELECT DECODE_TRACE_ID(LAST_TRACE_ID());
The execution result is as follows:
+----------------------------------+
| DECODE_TRACE_ID(LAST_TRACE_ID()) |
+----------------------------------+
| xxx.xx.xxx.xx1:2882 |
+----------------------------------+
1 row in set