Hello out there,
last weekend I migrated a database from 10.2.0.5 to 11.2.0.2 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

select
username,
timestamp,
logoff_time-timestamp time_logged_id
from
dba_audit_session

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?

Regards,
Lothar

On 20.04.2011 15:21, Lothar Armbrüster wrote:
Lothar, i remember, there was a discussion on oracle-l a while ago
regarding this behaviour

http://www.freelists.org/post/oracle...ME-are-equal,9


Best regards

Maxim

Maxim Demenko <mdemenko (AT) gmail (DOT) com> writes:


Thanks,
Lothar

--
Lothar Armbrüster | lothar.armbruester (AT) t-online (DOT) de
Hauptstr. 26 |
65346 Eltville |

On Apr 20, 1:13*pm, Maxim Demenko <mdeme... (AT) gmail (DOT) com> wrote:
Maxim, good info. If I knew that I had forgotten the behavior change.

-- Mark D Powell --