Syntax
DECODE_TRACE_ID()
Purpose
DECODE_TRACE_ID() parses a trace_id value and returns the IP address and port number of the server where the SQL request is initiated. You can query the GV$OB_SQL_AUDIT view for related information.
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