V$CLIENT_ERRORS View

Describes the columns in the V$CLIENT_ERRORS View.

Column Name Datatype Description
SID NUMBER

The session identifier, as also seen in v$session.sid.

SERIAL# NUMBER

The session serial number, as also seen in v$session.serial#.

USERNAME VARCHAR2(128)

User ID of the user performing the operation.

MODULE VARCHAR2(64)

If this was set using DBMS_APPLICATION_INFO.SET_MODULE, that value is captured in this column. Same as v$sql.MODULE.

ACTION VARCHAR2(64) If this was set using DBMS_APPLICATION_INFO.SET_ACTION, that value is captured in this column. Same as v$sql.ACTION.
SQLID VARCHAR2(13) The SQL identifier of the SQL/PLSQL statement that resulted in the error.
ERROR_NUM NUMBER

The oracle error number at the top of error stack.

ERROR_MESSAGE VARCHAR2(4000)

Complete Oracle error message including PLSQL callstack, if it was part of error message.

ERROR_TIME TIMESTAMP(9)

Time in UTC, when error occurred.

CON_ID NUMBER Container ID.