Re: WAIT EVENTS

From: Tim Gorman <tim_at_sagelogix.com>
Date: Thu, 06 May 2004 20:42:59 -0600
Message-ID: <BCC053D3.148D5%tim@sagelogix.com>

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

on 5/6/04 2:23 PM, Seema Singh at oracledbam_at_hotmail.com 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_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 Thu May 06 2004 - 21:39:53 CDT