Re: v$active_Session_history column question
- From: Mogens Nørgaard <mln@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 Jul 2004 08:29:28 +0200
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
