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
|
SERIAL# |
NUMBER |
The session serial number, as also seen in
|
USERNAME |
VARCHAR2(128) |
User ID of the user performing the operation. |
MODULE |
VARCHAR2(64)
|
If this was set using
|
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. |
Parent topic: Autonomous Database Views