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. |