Lockdown Errors View
Lists
details for the DBA_LOCKDOWN_ERRORS view.
- DBA_LOCKDOWN_ERRORS View
TheDBA_LOCKDOWN_ERRORSview provides information about SQL statements where lockdown profile errors were generated.
Parent topic: Autonomous Database Views
DBA_LOCKDOWN_ERRORS View
The
DBA_LOCKDOWN_ERRORS view provides information about SQL statements
where lockdown profile errors were generated.
| Column | Datatype | NULL | Description |
|---|---|---|---|
LAST_OCCURRENCE |
TIMESTAMP(6) |
Timestamp of latest execution failure. | |
OCCURRENCE_COUNT |
NUMBER |
Total occurrences of execution failure. | |
ERROR_NUM |
NUMBER |
Error number | |
ERROR_MSG |
VARCHAR2(4000) |
Error message | |
RULE_TYPE |
VARCHAR2(128) |
Lockdown Profile Rule type: STATEMENT, OPTIONS, FEATURE, EXECUTION |
|
SQL_TEXT |
CLOB |
SQL text | |
SQL_ID |
VARCHAR2(13) |
SQL_ID of statement that hit lockdown error. | |
SESSION_ID |
NUMBER |
Session identifier. | |
SESSION_SERIAL |
NUMBER |
Session serial number. | |
SCHEMA |
VARCHAR2(128) |
User's current schema. | |
MODULE |
VARCHAR2(64) |
Name of the currently executing module. | |
ACTION |
VARCHAR2(64) |
Name of the currently executing action | |
CLIENT_ID |
VARCHAR2(64) |
Client identifier of the session. | |
USER# |
NUMBER |
NOT NULL |
ID number of the user. |
USERNAME |
VARCHAR2(128) |
NOT NULL |
Name of the user. |
LUSER# |
NUMBER |
NOT NULL |
ID number of the Logon user |
LUSERNAME |
VARCHAR2(128) |
NOT NULL |
Name of the logon user. |
Parent topic: Lockdown Errors View