Declaration
DECODE_TRACE_ID()
Description
The DECODE_TRACE_ID() function is used to parse a trace ID and return the IP address and port number of the server that initiated the SQL request. You can also view related information through the GV$OB_SQL_AUDIT view.
Examples
obclient [(none)]> SELECT DECODE_TRACE_ID(LAST_TRACE_ID());
The return result is as follows:
+----------------------------------+
| DECODE_TRACE_ID(LAST_TRACE_ID()) |
+----------------------------------+
| xxx.xx.xxx.xx1:2882 |
+----------------------------------+
1 row in set