AUD$ TIMESTAMP and LOGOFF_TIME are equal
From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Mon, 28 Dec 2009 13:48:53 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF016476F1_at_WIN02.hotsos.com>
Database 11.1.0.7 on a 6 way RAC, each node has 16 CPUs. (That's all the info I have on the system, I'm working remote)
Date: Mon, 28 Dec 2009 13:48:53 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF016476F1_at_WIN02.hotsos.com>
Database 11.1.0.7 on a 6 way RAC, each node has 16 CPUs. (That's all the info I have on the system, I'm working remote)
Data collected from AUD$ via the DBA_AUDIT_SESSION view has the TIMESTAMP and LOGOFF_TIME equal for the vast majority of the sessions collected. Which is not possible, some of these sessions did over a billion LIOs in what appears to be "no time".
I've been searching Metalink and Google with no success on finding anything. Anyone out there seen anything like this?
Thanks much and have a great New Year!
Ric Van Dyke
Hotsos Enterprises
Hotsos Symposium
March 7 - 11, 2010
Be there.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 28 2009 - 13:48:53 CST