Lockdown Errors View

Lists details for the DBA_LOCKDOWN_ERRORS view.

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.