Login ond logoff time in DBA_AUDIT_SESSION

From: Lothar Armbrüster <l.armbruester_at_vertriebsunion.de>
Date: Wed, 20 Apr 2011 06:21:21 -0700 (PDT)
Message-ID: <892ce052-56f4-44d2-a630-a0bef0b3c5b3_at_p6g2000vbn.googlegroups.com>

Hello out there,
last weekend I migrated a database from to vie dbexport/dbimport.
Everything runs fine but I found out that DBA_AUSDIT_SESSION shows the same time in TIMESTAMP and LOGOFF_TIME.
Sessions are audited by audit session whenever successful. On the old database I could get the thime a user was logged in via


   logoff_time-timestamp time_logged_id


On the new database this always gives 0. I tried using extended_timestamp but then the difference is just the milliseconds.

Do I overlook something?

Lothar Received on Wed Apr 20 2011 - 08:21:21 CDT

Original text of this message