Re: v$active_Session_history column question

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Tue, 13 Jul 2004 06:19:57 -0700 (PDT)
Message-ID: <20040713131957.18370.qmail@web41509.mail.yahoo.com>

Harvinder:

Most of the timing information from V$views are centi-seconds (1/100th of a second) unless specified. I don't have 10g database handy. So I may not be able to confirm this. Myself and Kirti were doing some analysis during chapter-10 of our book.

As you have seen, it does not have a direct relationship with other views. V$ASH will have the details about the ACTIVE waits (by active here, I mean the session is waiting for I/O, on CPU, waiting for a buffer or message from remote instance in case of RAC,waits during PARSE/EXECUTE or FETCH and any other wait which are not classified as IDLE wait).

If you have our book handy, have a look at chapter-09 (Performance Management with Oracle Database 10g).

Have a nice day !!

Best Regards,
K Gopalakrishnan,
Co-Author: Oracle Wait Interface: Oracle Press 2004. http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Tue Jul 13 2004 - 08:16:42 CDT