Re: WAIT EVENTS

  • From: Tim Gorman <tim@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 06 May 2004 20:42:59 -0600

You are using MTS/SS in an idle database instance.



on 5/6/04 2:23 PM, Seema Singh at oracledbam@xxxxxxxxxxx wrote:

> Hi,
> My system waitevents show follwoing stats.
>                               Total       Total        Time
> Avg
>                                Waits    Timeouts      Waited    % of
> Wait
> Event Name                  (in 1000s)  (in 1000s)  (in Hours) Concern
> (Secs)
> -------------------------- ----------- ----------- ----------- -------
> -------
> virtual circuit status           24.67       24.67      147.33   65.24
> 21.50  <-----
> dispatcher timer                  8.10        8.10       75.00   33.21
> 33.34  <------
> direct path write               464.78        0.00        1.52    0.67
> 0.01
> control file parallel writ      161.14        0.00        0.50    0.22
> 0.01
> db file sequential read         722.82        0.00        0.41    0.18
> 0.00
> direct path read                591.98        0.00        0.37    0.16
> 0.00

----------------------------------------------------------------
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: