Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: oracle is causing high WIO

Re: oracle is causing high WIO

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Mon, 24 Oct 2005 19:59:33 +0200
Message-ID: <008501c5d8c4$b57042b0$3508310a@IBME1D11967173>


Try prstat -m and check the major contributors for the % of SYS mode. I *think* the kernel mode includes the IO device wait time.

/app/oracle$ prstat -m

   PID USERNAME USR SYS TRP TFL DFL LCK SLP LAT VCX ICX SCL SIG PROCESS/NLWP

 11603 oracle    56 3.3 0.0 0.0 0.0 0.0  39 1.3  1K  73  1K   0 oracle/1
 24601 oracle    11 3.6 0.0 0.0 0.0 0.0  86 0.0 160  17  6K   0 oracle/1
 24599 oracle   6.2 4.1 0.0 0.0 0.0 0.0  90 0.0 138   5  5K   0 oracle/1



HTH,
Dimitre

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 24 2005 - 13:01:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US