Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Dba Audit Trail and Sys.Aud$

683115Feb 3 2009 — edited Feb 4 2009

Hi everyone.

Why, if I do this in SQLPlus console, this happens?

1. SELECT username, timestamp, logoff_time from dba_audit_trail
This returns, for example: PETE 02/01/2009 03/01/2009

2. SELECT userid, timestamp#, logoff$time from sys.aud$
This returns: PETE *[NULL]* 03/01/2009

So I mean, dba_audit_trail records the loggON date, but their copy in the sys.aud$ NEVER SAVE the logoon date, anybody know why this happens?
Whats the real difference betwen dba_audit tables (trail) and Sys.Aud$.

I need this solution, please.

Thanks in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2009

Added on Feb 3 2009

#general-database-discussions

4 comments

12,383 views