Oracle-L: I/O EVENTS

From: S B <bhulubhuli_at_yahoo.com>
Date: Thu, 16 May 2002 01:33:20 -0800
Message-ID: <F001.00461FEF.20020516013320@fatcity.com>

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

Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: S B
INET: bhulubhuli_at_yahoo.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 - 04:33:20 CDT