SESSION_ID
|
NUMBER
|
NOT NULL
|
Session id of the query
|
TIMESTAMP
|
DATE
|
NOT NULL
|
Timestamp of the query
|
DB_USER
|
VARCHAR2(30)
|
|
Database username who executed the query
|
OS_USER
|
VARCHAR2(255)
|
|
Operating system username who executed the query
|
USERHOST
|
VARCHAR2(128)
|
|
Numeric instance ID for the Oracle instance from which the user is accessing the database. Used only in environments with distributed file systems and shared database files.
|
CLIENT_ID
|
VARCHAR2(64)
|
|
Client identifier in each Oracle session
|
EXT_NAME
|
VARCHAR2(4000)
|
|
External name
|
OBJECT_SCHEMA
|
VARCHAR2(30)
|
|
Owner of the table or view
|
OBJECT_NAME
|
VARCHAR2(128)
|
|
Name of the table or view
|
POLICY_NAME
|
VARCHAR2(30)
|
|
Name of the Fine-Grained Auditing Policy
|
SCN
|
NUMBER
|
|
System change number (SCN) of the query
|
SQL_TEXT
|
NVARCHAR2(2000)
|
|
SQL text of the query
|
SQL_BIND
|
VARCHAR2(4000)
|
|
Bind variable data of the query
|
COMMENT$TEXT
|
VARCHAR2(4000)
|
|
Comments
|