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)  

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-l

Received on Mon Dec 28 2009 - 13:48:53 CST