Re: v$active_Session_history column question

From: Mogens Nørgaard <mln_at_miracleas.dk>
Date: Wed, 14 Jul 2004 08:29:28 +0200
Message-ID: <40F4D2C8.1070502@miracleas.dk>

And make sure you're not violating the license rules of Oracle. You are not allowed to look in v$active_session_history if you haven't bought various OEM Packs :-).

Mogens

K Gopalakrishnan wrote:

> 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).
>

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 Wed Jul 14 2004 - 01:26:03 CDT