AUD$ TIMESTAMP and LOGOFF_TIME are equal

  • From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
  • To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 28 Dec 2009 13:48:53 -0600

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.

 

 

 

Other related posts: