how dba audit is enabled, at statement, user or database level ! the purpose of each v$view is/are different...v$session will inform inly about current session where as dba_audit_session will have record only if audit trail is enabled On 19 January 2011 01:19, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx>wrote: > This one is driving me crazy. If I count the number of sessions from > v$session that a particular user has and then look in dba_audit_sessions for > the corresponding audit records they do not match. I'm short about 40 > records. > > Dick Goulet > Senior Oracle DBA > > -- ============================== DO NOT FORGET TO SMILE TODAY ==============================