DECODE_TRACE_ID

Declaration

DECODE_TRACE_ID()

Description

The DECODE_TRACE_ID() function is used to parse the trace_id and return the IP address and port number of the server where the SQL request originated. You can also view this information in the GV$OB_SQL_AUDIT view.

Examples

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 (0.000 sec)