Oracle 11gR1
DBA_AUDIT_SESSION displays all audit trail records concerning CONNECT and DISCONNECT.
USER_AUDIT_SESSION contains audit trail records concerning connections and disconnections of the current user.
| Column | Datatype | NULL | Description |
|
|
| | Operating system login username of the user whose actions were audited |
|
|
| | Name (not ID number) of the user whose actions were audited |
|
|
| | Client host machine name |
|
|
| | Identifier of the user's terminal |
|
|
| | Date and time of the creation of the audit trail entry (date and time of user login for entries created by |
|
|
| | Name of the action type corresponding to the numeric code in the |
|
|
| | Date and time of user log off |
|
|
| | Logical reads for the session |
|
|
| | Physical reads for the session |
|
|
| | Logical writes for the session |
|
|
| | Deadlocks detected during the session |
|
|
|
| Numeric ID for each Oracle session |
|
|
|
| Oracle error code generated by the action. Some useful values: · · |
|
|
| | Client identifier in each Oracle session |
|
|
| | Amount of CPU time used by each Oracle session |
|
|
| | Timestamp of the creation of the audit trail entry (timestamp of user login for entries created by |
|
|
| | Proxy session serial number, if an enterprise user has logged in through the proxy mechanism |
|
|
| | Global user identifier for the user, if the user has logged in as an enterprise user |
|
|
| | Instance number as specified by the |
|
|
| | Operating System process identifier of the Oracle process |
No comments:
Post a Comment