Re: Understanding DBA_AUDIT_SESSION

OK, Here is the short description of the DBA_AUDIT_SESSION's columns (founded in the manual)

TIMESTAMP
 Timestamp for the creation of the audit trail entry or login time for the CONNECT statement
ACTION_NAME
 Name of the action type corresponding to the numeric code in the ACTION column in DBA_AUDIT_TRAIL
LOGOFF_TIME
 Timestamp for user log off

So, We've got

 USERNAME                       TIMESTAMP | ACTION_NAME
LOGOFF_TIME  | RETURNCODE
 SCOTT                            30-04 09:04:29  LOGOFF
30-04 09:04:31          0

And is it means, that scott logged off at 30-04 09:04:31 and the record was written to the audittrail at 30-04 09:04:29??

MW

"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message news:3eafd47a$0$49117$e4fe514c_at_news.xs4all.nl...
> ORA-02002 error while writing to audit trail
> Cause: The auditing facility is unable to write to the AUDIT_TRAIL table.
If
> this error occurs, SQL statements that are currently being audited may
also
> fail.
> This error will occur if the SYSTEM tablespace runs out of disk space.
> Action: Add space to the SYSTEM tablespace or delete rows from the AUDIT_
> TRAIL table. If these operations fail or do not eliminate the problem,
shut
> down
> and restart Oracle with auditing disabled. This is done by setting the
> initialization parameter AUDIT_TRAIL to FALSE.
>
> Timestamp is the timestamp when the record was written to the audittrail.
> See Oracle Reference manual (http://tahiti.oracle.com) for a description
> of all dictionary views. (The Error Messages manual is there too).
>
>
>
Received on Wed Apr 30 2003 - 11:10:24 CDT