Oracle-L: RE: I/O EVENTS

From: Hately Mike <Mike.Hately_at_churchill.com>
Date: Thu, 16 May 2002 02:14:38 -0800
Message-ID: <F001.00462135.20020516021438@fatcity.com>

Hi,
far better than getting individual descriptions is to research for yourself
(this isn't an RTFM message honestly).

Good sources of information for this subject are Anjo Kolk's excellent document on wait events and enqueues
(http://www.dbatoolbox.com/WP2001/dbamisc/events.pdf) and the Oracle
documentation set, specifically the Oracle Server Reference (Appendix A I think), wait events.

Cheers,
Mike

-----Original Message-----
Sent: 16 May 2002 10:33
To: Multiple recipients of list ORACLE-L

Can anybody explain the events like
SQL*Net message from client,rdbms ipc message PX Idle Wait ,slave wait ...

Can I assume a i/o bottleneck from the following statistics as most of the i/o events are having high wait time.

select * from v$system_event
order by TIME_WAITED;

The last few entries are as follows.....

EVENT                           TOTAL_WAITS

TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT

SQL*Net more data to client 888137 0 12365 0.013922402
db file parallel write 2445 0 17606 7.200818
db file scattered read 7823 0 18336 2.34385786
db file sequential read 27779 0 55490 1.99755211
control file parallel write 27194 0 70593 2.59590351

log file sync                      	29700	1	145295	
4.89208754
log file parallel write            	30511	2	146311	
4.7953525
io done                            	35551	567	270796	
7.61711344
smon timer                         	278	273	8404285	
30231.241
pmon timer                         	27350	27349
8413237		307.613784
SQL*Net message from client        	498526	0	17655561
35.415527
rdbms ipc message                  	112693	80775
33193981	294.552288
PX Idle Wait                       	164145	164139
33650049	205.001974
slave wait                         	433146	392872
40839651	94.2861091

Regards
Bhulu

This email and any attached to it are confidential and intended only for the individual or
entity to which it is addressed. If you are not the intended recipient, please let us know
by telephoning or emailing the sender. You should also delete the email and any attachment
from your systems and should not copy the email or any attachment or disclose their content
to any other person or entity. The views expressed here are not necessarily those of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England.
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  INET: Mike.Hately_at_churchill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu May 16 2002 - 05:14:38 CDT