RE: AUD$ TIMESTAMP and LOGOFF_TIME are equal

I remember reading on MOS that said what Dave said earlier "if the session ends properly, TIMESTAMP and LOGOFF_TIME should be the same." At logoff time, the timestamp is updated to that time, unless the action is 'LOGOFF BY CLEANUP', i.e. the session terminates abnormally.

I didn't find that note, but found Note:271615.1 that says "From 10g onwards the time shown in TIMESTAMP and LOGOFF_TIME columns are in different time zones". I thought that would create a difference in query result. But no. TIMESTAMP of the dba_audit_* views in 10g and up is already converted to the local timezone, even though the ntimestamp# column of aud$ is in UTC. Ric, you're talking about the columns of dba_audit_*, not aud$. What you see is normal.

Yong Huang       

--
http://www.freelists.org/webpage/oracle-l