Top Activity in Percentage

From: LS Cheng <exriscer_at_gmail.com>
Date: Sat, 5 Nov 2011 15:51:50 +0100
Message-ID: <CAJ2-Qb9j3pWU7MciDstr5HO-RUs=7W8KBd7xLVBiDcA++BmMPA_at_mail.gmail.com>

Hi
I wonder if anyone know how to obtain top activity in percentage using SQL as viewed from Enterprise Manager as explained in

http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/img/top_activity_new.gif http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/img_text/top_activity_new.htm

I believe it gathers the data from v$active_session_history using 5 minutes as time deltas?

Thanks a lot

--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Sat Nov 05 2011 - 09:51:50 CDT