Purpose
The USER_AUDIT_SESSION view displays audit trail records on connections and disconnections of the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
DBA_AUDIT_SESSION
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OS_USERNAME | VARCHAR2(255) | NO | The username of the user whose actions were audited, where the username is used for operating system (OS) logon. At present, this column is not supported and is NULL by default. |
| USERNAME | VARCHAR2(64) | NO | The username of the user whose actions were audited. |
| USERHOST | VARCHAR2(32) | NO | The name of the client host. At present, this column is not supported and is NULL by default. |
| TERMINAL | VARCHAR2(255) | NO | The identifier of the user terminal. At present, this column is not supported and is NULL by default. |
| TIMESTAMP | DATE | NO | The date and time when the audit trail entry was created in the time zone of the local database session. |
| ACTION_NAME | VARCHAR2(128) | NO | The name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL. |
| LOGOFF_TIME | DATE | NO | The date and time when the user was logged off. |
| LOGOFF_LREAD | NUMBER(38) | NO | The logical reads for the session. |
| LOGOFF_PREAD | NUMBER | NO | The physical reads for the session. At present, this column is not supported and is NULL by default. |
| LOGOFF_LWRITE | NUMBER | NO | The logical writes for the session. At present, this column is not supported and is NULL by default. |
| LOGOFF_DLOCK | VARCHAR2(40) | NO | Indicates whether deadlocks are detected during the session. At present, this column is not supported and is NULL by default. |
| SESSIONID | NUMBER(38) | NO | The numeric ID of the session. |
| RETURNCODE | NUMBER(38) | NO | The error code generated by the action. |
| CLIENT_ID | VARCHAR2(40) | NO | The client identifier in the session. |
| SESSION_CPU | NUMBER(38) | NO | The amount of CPU time used by the session. |
| EXTENDED_TIMESTAMP | TIMESTAMP(6) WITH TIME ZONE | NO | The timestamp of when the audit trail entry was created in the Coordinated Universal Time (UTC) time zone. |
| PROXY_SESSIONID | NUMBER(38) | NO | The serial number of the proxy session. |
| GLOBAL_UID | NUMBER(38) | NO | The global user identifier (UID) of the user. |
| INSTANCE_NUMBER | VARCHAR2(40) | NO | The instance number specified by the INSTANCE_NUMBER initialization parameter. At present, this column is not supported and is NULL by default. |
| OS_PROCESS | VARCHAR2(40) | NO | The OS process identifier of the process. At present, this column is not supported and is NULL by default. |