Active Session History

From: Laimutis Nedzinskas <Laimutis.Nedzinskas_at_landsbanki.is>
Date: Thu, 26 Apr 2007 18:09:27 -0000
Message-ID: <5A8896FB2AFC5445A7DCFC5903CCA6B06FED9A@W03856.li01r1d.lais.net>

Anyone has information about Active Session History views (both V$ and DBA) So far I have more questions than answers how those views can be used...

I am especially interested in the wait events columns like EVENTS_ID, TIME_WAITED, WAIT_TIME. What is funny enough is that EVENT_ID column is often just null in v$ view.

Thank you in advance,
Laimis N

Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 26 2007 - 13:09:27 CDT