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: Method R and CPU Time

RE: Method R and CPU Time

From: MacGregor, Ian A. <ian_at_slac.stanford.edu>
Date: Wed, 7 Jul 2004 10:27:25 -0700
Message-ID: <26E3EC48949D134C94A1574B2C89466113A971@exchange2.slac.stanford.edu>


To be more complete I've decided to provide the data for a single run of the statement.  First the data before the first fetch call /opt/oracle/admin/NLCO/udump/nlco_ora_2991.trc Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production With the Partitioning option
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /opt/oracle/dbserver/9.2.0 System name: SunOS

Node name:      xxxxx
Release:        5.8
Version:        Generic_108528-27
Machine:        sun4u

Instance name: NLCO
Redo thread mounted by this instance: 1
Oracle process number: 29
Unix process pid: 2991, image: oracle_at_xxxxx (TNS V1-V3)
WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0
WAIT #1: nam='db file scattered read' ela= 20722 p1=185 p2=151250 p3=7
WAIT #1: nam='db file scattered read' ela= 22832 p1=186 p2=14969 p3=8
WAIT #1: nam='db file scattered read' ela= 20948 p1=187 p2=1012385 p3=8
WAIT #1: nam='db file scattered read' ela= 20795 p1=187 p2=1012401 p3=8
WAIT #1: nam='db file sequential read' ela= 3105 p1=435 p2=26633 p3=1
WAIT #1: nam='db file scattered read' ela= 19755 p1=185 p2=151258 p3=7
WAIT #1: nam='db file scattered read' ela= 21336 p1=186 p2=14977 p3=8
WAIT #1: nam='db file scattered read' ela= 21461 p1=187 p2=1012409 p3=8
WAIT #1: nam='db file scattered read' ela= 21565 p1=187 p2=1012433 p3=8
WAIT #1: nam='db file scattered read' ela= 12841 p1=187 p2=1048537 p3=4
WAIT #1: nam='db file scattered read' ela= 19139 p1=185 p2=167658 p3=7
WAIT #1: nam='db file scattered read' ela= 20505 p1=186 p2=19873 p3=8
WAIT #1: nam='db file scattered read' ela= 23120 p1=187 p2=1048545 p3=8
WAIT #1: nam='db file scattered read' ela= 21120 p1=187 p2=1048569 p3=8
WAIT #1: nam='db file sequential read' ela= 2795 p1=435 p2=11289 p3=1
WAIT #1: nam='db file scattered read' ela= 18413 p1=185 p2=167666 p3=7
WAIT #1: nam='db file scattered read' ela= 20973 p1=186 p2=21153 p3=8
WAIT #1: nam='db file scattered read' ela= 27766 p1=187 p2=3777 p3=8
WAIT #1: nam='db file scattered read' ela= 31294 p1=435 p2=11273 p3=8
WAIT #1: nam='db file scattered read' ela= 9806 p1=436 p2=4881 p3=3
WAIT #1: nam='db file scattered read' ela= 22845 p1=185 p2=167698 p3=7
WAIT #1: nam='db file scattered read' ela= 21376 p1=186 p2=21257 p3=8
WAIT #1: nam='db file scattered read' ela= 21038 p1=187 p2=236313 p3=8
WAIT #1: nam='db file scattered read' ela= 22907 p1=435 p2=35593 p3=8
WAIT #1: nam='db file scattered read' ela= 11586 p1=186 p2=221137 p3=4
WAIT #1: nam='db file scattered read' ela= 20870 p1=185 p2=168434 p3=7
WAIT #1: nam='db file scattered read' ela= 22412 p1=186 p2=21433 p3=8
WAIT #1: nam='db file scattered read' ela= 22774 p1=187 p2=236321 p3=8
WAIT #1: nam='db file scattered read' ela= 29823 p1=435 p2=37137 p3=7
WAIT #1: nam='db file scattered read' ela= 20786 p1=185 p2=168442 p3=7
WAIT #1: nam='db file scattered read' ela= 22988 p1=186 p2=21465 p3=8
WAIT #1: nam='db file scattered read' ela= 24596 p1=187 p2=236369 p3=8
WAIT #1: nam='db file scattered read' ela= 22325 p1=435 p2=37145 p3=8
WAIT #1: nam='db file sequential read' ela= 3006 p1=185 p2=742737 p3=1
WAIT #1: nam='db file scattered read' ela= 18306 p1=185 p2=169114 p3=7
WAIT #1: nam='db file scattered read' ela= 22559 p1=186 p2=22793 p3=8
WAIT #1: nam='db file scattered read' ela= 21741 p1=187 p2=236377 p3=8
WAIT #1: nam='db file scattered read' ela= 19578 p1=435 p2=37153 p3=7
WAIT #1: nam='db file scattered read' ela= 26087 p1=185 p2=169306 p3=7
WAIT #1: nam='db file scattered read' ela= 41955 p1=186 p2=22809 p3=8
WAIT #1: nam='db file scattered read' ela= 30428 p1=187 p2=236393 p3=8
WAIT #1: nam='db file scattered read' ela= 22956 p1=435 p2=37161 p3=8
WAIT #1: nam='db file sequential read' ela= 2802 p1=185 p2=742753 p3=1
WAIT #1: nam='db file scattered read' ela= 20919 p1=185 p2=169314 p3=7
WAIT #1: nam='db file scattered read' ela= 25016 p1=186 p2=22817 p3=8
WAIT #1: nam='db file scattered read' ela= 24513 p1=187 p2=236401 p3=8
WAIT #1: nam='db file scattered read' ela= 21338 p1=435 p2=37201 p3=8
WAIT #1: nam='db file scattered read' ela= 5974 p1=185 p2=742769 p3=2
WAIT #1: nam='db file scattered read' ela= 18828 p1=185 p2=169322 p3=7
WAIT #1: nam='db file scattered read' ela= 23685 p1=186 p2=22825 p3=8
WAIT #1: nam='db file scattered read' ela= 20407 p1=187 p2=236409 p3=8
WAIT #1: nam='db file scattered read' ela= 23797 p1=435 p2=37209 p3=8
WAIT #1: nam='db file scattered read' ela= 11224 p1=186 p2=56457 p3=4
WAIT #1: nam='db file scattered read' ela= 18555 p1=185 p2=169330 p3=7
WAIT #1: nam='db file scattered read' ela= 21408 p1=186 p2=22833 p3=8
WAIT #1: nam='db file scattered read' ela= 21822 p1=187 p2=236417 p3=8
WAIT #1: nam='db file scattered read' ela= 21305 p1=435 p2=37217 p3=8
WAIT #1: nam='db file scattered read' ela= 20284 p1=186 p2=219961 p3=7
WAIT #1: nam='db file scattered read' ela= 19023 p1=185 p2=169338 p3=7
WAIT #1: nam='db file scattered read' ela= 23902 p1=186 p2=22841 p3=8
WAIT #1: nam='db file scattered read' ela= 25362 p1=187 p2=237585 p3=8
WAIT #1: nam='db file scattered read' ela= 24377 p1=435 p2=37225 p3=8
WAIT #1: nam='db file scattered read' ela= 15109 p1=186 p2=219969 p3=4
WAIT #1: nam='db file scattered read' ela= 19469 p1=185 p2=169346 p3=7
WAIT #1: nam='db file scattered read' ela= 23040 p1=186 p2=22849 p3=8
WAIT #1: nam='db file scattered read' ela= 23958 p1=187 p2=237593 p3=8
WAIT #1: nam='db file scattered read' ela= 25863 p1=435 p2=37233 p3=8
WAIT #1: nam='db file scattered read' ela= 9082 p1=186 p2=219977 p3=3
WAIT #1: nam='db file scattered read' ela= 19292 p1=185 p2=169866 p3=7
WAIT #1: nam='db file scattered read' ela= 25072 p1=186 p2=22857 p3=8
WAIT #1: nam='db file scattered read' ela= 23030 p1=187 p2=237601 p3=8
WAIT #1: nam='db file scattered read' ela= 21108 p1=186 p2=219985 p3=8
WAIT #1: nam='db file scattered read' ela= 11552 p1=187 p2=237609 p3=4
WAIT #1: nam='db file scattered read' ela= 21614 p1=185 p2=169874 p3=7
WAIT #1: nam='db file scattered read' ela= 21887 p1=186 p2=22865 p3=8
WAIT #1: nam='db file scattered read' ela= 21623 p1=187 p2=237617 p3=8
WAIT #1: nam='db file scattered read' ela= 21497 p1=186 p2=219993 p3=8
WAIT #1: nam='db file scattered read' ela= 11186 p1=187 p2=237625 p3=4
WAIT #1: nam='db file scattered read' ela= 18814 p1=185 p2=169882 p3=7
WAIT #1: nam='db file scattered read' ela= 20471 p1=186 p2=22873 p3=8
WAIT #1: nam='db file scattered read' ela= 21422 p1=187 p2=237641 p3=8
WAIT #1: nam='db file scattered read' ela= 23335 p1=186 p2=220001 p3=8
WAIT #1: nam='db file scattered read' ela= 5086 p1=187 p2=237649 p3=2
WAIT #1: nam='db file scattered read' ela= 18263 p1=185 p2=169890 p3=7
WAIT #1: nam='db file scattered read' ela= 21430 p1=186 p2=22881 p3=8
WAIT #1: nam='db file scattered read' ela= 20978 p1=187 p2=237689 p3=8
WAIT #1: nam='db file scattered read' ela= 21682 p1=186 p2=220009 p3=8
WAIT #1: nam='db file scattered read' ela= 8142 p1=187 p2=237697 p3=3
WAIT #1: nam='db file scattered read' ela= 19596 p1=185 p2=169898 p3=7
WAIT #1: nam='db file scattered read' ela= 20562 p1=186 p2=22889 p3=8
WAIT #1: nam='db file scattered read' ela= 22183 p1=187 p2=238713 p3=8
WAIT #1: nam='db file scattered read' ela= 38018 p1=186 p2=220025 p3=8
WAIT #1: nam='db file scattered read' ela= 12838 p1=187 p2=239945 p3=2
WAIT #1: nam='db file scattered read' ela= 32371 p1=185 p2=169906 p3=7
WAIT #1: nam='db file scattered read' ela= 30213 p1=186 p2=22897 p3=8
WAIT #1: nam='db file scattered read' ela= 35318 p1=187 p2=239953 p3=8
WAIT #1: nam='db file scattered read' ela= 27446 p1=186 p2=220305 p3=8
WAIT #1: nam='db file scattered read' ela= 6657 p1=187 p2=239961 p3=2
WAIT #1: nam='db file scattered read' ela= 26057 p1=185 p2=169914 p3=7
WAIT #1: nam='db file scattered read' ela= 33003 p1=186 p2=22905 p3=8
WAIT #1: nam='db file scattered read' ela= 31171 p1=187 p2=239977 p3=8
WAIT #1: nam='db file scattered read' ela= 26730 p1=186 p2=220313 p3=8
WAIT #1: nam='db file scattered read' ela= 22538 p1=187 p2=239985 p3=7
WAIT #1: nam='db file scattered read' ela= 23659 p1=185 p2=169922 p3=7
WAIT #1: nam='db file scattered read' ela= 31442 p1=186 p2=22913 p3=8
WAIT #1: nam='db file scattered read' ela= 28182 p1=187 p2=239993 p3=8
WAIT #1: nam='db file scattered read' ela= 29205 p1=186 p2=220345 p3=8
WAIT #1: nam='db file scattered read' ela= 18004 p1=187 p2=240009 p3=6
WAIT #1: nam='db file scattered read' ela= 22008 p1=185 p2=169930 p3=7
WAIT #1: nam='db file scattered read' ela= 25364 p1=186 p2=24841 p3=8
WAIT #1: nam='db file scattered read' ela= 24401 p1=187 p2=240017 p3=8
WAIT #1: nam='db file scattered read' ela= 24089 p1=186 p2=220353 p3=8
WAIT #1: nam='db file scattered read' ela= 10045 p1=187 p2=240057 p3=3
WAIT #1: nam='db file scattered read' ela= 23070 p1=185 p2=169938 p3=7
WAIT #1: nam='db file scattered read' ela= 26839 p1=186 p2=24849 p3=8
WAIT #1: nam='db file scattered read' ela= 24513 p1=187 p2=240065 p3=8
WAIT #1: nam='db file scattered read' ela= 24105 p1=186 p2=220361 p3=8
WAIT #1: nam='db file scattered read' ela= 22306 p1=185 p2=170106 p3=7
WAIT #1: nam='db file scattered read' ela= 25733 p1=186 p2=24857 p3=8
WAIT #1: nam='db file scattered read' ela= 25148 p1=187 p2=240073 p3=8
WAIT #1: nam='db file scattered read' ela= 26803 p1=186 p2=220369 p3=8
WAIT #1: nam='db file scattered read' ela= 10183 p1=187 p2=240081 p3=4
WAIT #1: nam='db file scattered read' ela= 20898 p1=185 p2=170386 p3=7
WAIT #1: nam='db file scattered read' ela= 24306 p1=186 p2=24865 p3=8
WAIT #1: nam='db file scattered read' ela= 23260 p1=187 p2=240089 p3=8
WAIT #1: nam='db file scattered read' ela= 22859 p1=186 p2=220401 p3=8
WAIT #1: nam='db file scattered read' ela= 12103 p1=187 p2=240097 p3=4
WAIT #1: nam='db file scattered read' ela= 22179 p1=185 p2=170394 p3=7
WAIT #1: nam='db file scattered read' ela= 22105 p1=186 p2=24873 p3=8
WAIT #1: nam='db file scattered read' ela= 24207 p1=187 p2=240105 p3=8
WAIT #1: nam='db file scattered read' ela= 20742 p1=186 p2=220409 p3=8
WAIT #1: nam='db file scattered read' ela= 7663 p1=187 p2=240113 p3=3
WAIT #1: nam='db file scattered read' ela= 19949 p1=185 p2=170418 p3=7
WAIT #1: nam='db file scattered read' ela= 23192 p1=186 p2=24897 p3=8
WAIT #1: nam='db file scattered read' ela= 21027 p1=187 p2=240121 p3=8
WAIT #1: nam='db file scattered read' ela= 21317 p1=186 p2=220417 p3=8
WAIT #1: nam='db file scattered read' ela= 13148 p1=187 p2=240137 p3=5
WAIT #1: nam='db file scattered read' ela= 20099 p1=185 p2=170426 p3=7
WAIT #1: nam='db file scattered read' ela= 21396 p1=186 p2=24905 p3=8
WAIT #1: nam='db file scattered read' ela= 22373 p1=187 p2=240145 p3=8
WAIT #1: nam='db file scattered read' ela= 26733 p1=186 p2=220833 p3=8
WAIT #1: nam='db file scattered read' ela= 15059 p1=187 p2=240153 p3=5
WAIT #1: nam='db file scattered read' ela= 19828 p1=185 p2=170434 p3=7
WAIT #1: nam='db file scattered read' ela= 24651 p1=186 p2=25473 p3=8
WAIT #1: nam='db file scattered read' ela= 27180 p1=187 p2=240161 p3=8
WAIT #1: nam='db file scattered read' ela= 24733 p1=186 p2=220841 p3=8
WAIT #1: nam='db file scattered read' ela= 16521 p1=187 p2=240169 p3=5
WAIT #1: nam='db file scattered read' ela= 21367 p1=185 p2=170442 p3=7
WAIT #1: nam='db file scattered read' ela= 23962 p1=186 p2=25993 p3=8
WAIT #1: nam='db file scattered read' ela= 20508 p1=187 p2=240177 p3=8
WAIT #1: nam='db file scattered read' ela= 21522 p1=186 p2=220849 p3=8
WAIT #1: nam='db file scattered read' ela= 14113 p1=187 p2=240185 p3=5
WAIT #1: nam='db file scattered read' ela= 18864 p1=185 p2=170498 p3=7
WAIT #1: nam='db file scattered read' ela= 20993 p1=186 p2=26001 p3=8
WAIT #1: nam='db file scattered read' ela= 22488 p1=187 p2=240193 p3=8
WAIT #1: nam='db file scattered read' ela= 22166 p1=186 p2=220857 p3=8
WAIT #1: nam='db file scattered read' ela= 10632 p1=187 p2=240201 p3=4
WAIT #1: nam='db file scattered read' ela= 34931 p1=185 p2=172402 p3=7
WAIT #1: nam='db file scattered read' ela= 46484 p1=186 p2=26009 p3=8
WAIT #1: nam='db file scattered read' ela= 33401 p1=187 p2=240209 p3=8
WAIT #1: nam='db file scattered read' ela= 29827 p1=186 p2=220881 p3=8
WAIT #1: nam='db file scattered read' ela= 14735 p1=187 p2=240217 p3=4
WAIT #1: nam='db file scattered read' ela= 23544 p1=185 p2=172426 p3=7
WAIT #1: nam='db file scattered read' ela= 25280 p1=186 p2=26017 p3=8
WAIT #1: nam='db file scattered read' ela= 24445 p1=187 p2=240225 p3=8
WAIT #1: nam='db file scattered read' ela= 25985 p1=186 p2=220889 p3=8
WAIT #1: nam='db file scattered read' ela= 15650 p1=187 p2=240233 p3=4
WAIT #1: nam='db file scattered read' ela= 21545 p1=185 p2=172434 p3=7
WAIT #1: nam='db file scattered read' ela= 25583 p1=186 p2=26025 p3=8
WAIT #1: nam='db file scattered read' ela= 26964 p1=187 p2=240241 p3=8
WAIT #1: nam='db file scattered read' ela= 26074 p1=186 p2=220897 p3=8
WAIT #1: nam='db file scattered read' ela= 18595 p1=187 p2=240393 p3=5
WAIT #1: nam='db file scattered read' ela= 22638 p1=185 p2=172458 p3=7
WAIT #1: nam='db file scattered read' ela= 23400 p1=186 p2=26033 p3=8
WAIT #1: nam='db file scattered read' ela= 24869 p1=187 p2=240425 p3=8
WAIT #1: nam='db file scattered read' ela= 25914 p1=186 p2=220905 p3=8
WAIT #1: nam='db file scattered read' ela= 11553 p1=187 p2=240457 p3=4
WAIT #1: nam='db file scattered read' ela= 22457 p1=185 p2=172466 p3=7
WAIT #1: nam='db file scattered read' ela= 25582 p1=186 p2=26081 p3=8
WAIT #1: nam='db file scattered read' ela= 26616 p1=187 p2=240465 p3=8
WAIT #1: nam='db file scattered read' ela= 27223 p1=186 p2=220913 p3=8
WAIT #1: nam='db file scattered read' ela= 8986 p1=187 p2=240489 p3=3
WAIT #1: nam='db file scattered read' ela= 21459 p1=185 p2=172474 p3=7
WAIT #1: nam='db file scattered read' ela= 27577 p1=186 p2=26089 p3=8
WAIT #1: nam='db file scattered read' ela= 25192 p1=187 p2=240649 p3=8
WAIT #1: nam='db file scattered read' ela= 26168 p1=186 p2=220921 p3=8
WAIT #1: nam='db file scattered read' ela= 16218 p1=187 p2=240665 p3=5
WAIT #1: nam='db file scattered read' ela= 26073 p1=185 p2=172482 p3=7
WAIT #1: nam='db file scattered read' ela= 22457 p1=186 p2=26097 p3=8
WAIT #1: nam='db file scattered read' ela= 20975 p1=187 p2=240673 p3=8
WAIT #1: nam='db file scattered read' ela= 20655 p1=186 p2=220929 p3=8
WAIT #1: nam='db file sequential read' ela= 2523 p1=187 p2=242969 p3=1
WAIT #1: nam='db file scattered read' ela= 18940 p1=185 p2=172490 p3=7
WAIT #1: nam='db file scattered read' ela= 22032 p1=186 p2=26105 p3=8
WAIT #1: nam='db file scattered read' ela= 22259 p1=187 p2=240681 p3=8
WAIT #1: nam='db file scattered read' ela= 23976 p1=186 p2=221097 p3=8
WAIT #1: nam='db file scattered read' ela= 9698 p1=187 p2=240689 p3=3
WAIT #1: nam='db file scattered read' ela= 22768 p1=185 p2=172498 p3=7
WAIT #1: nam='db file scattered read' ela= 25555 p1=186 p2=26249 p3=8
WAIT #1: nam='db file scattered read' ela= 25879 p1=187 p2=240697 p3=8
WAIT #1: nam='db file scattered read' ela= 27733 p1=186 p2=221105 p3=8
WAIT #1: nam='db file scattered read' ela= 24622 p1=185 p2=172506 p3=7
WAIT #1: nam='db file scattered read' ela= 25409 p1=186 p2=26257 p3=8
WAIT #1: nam='db file scattered read' ela= 31346 p1=187 p2=240769 p3=8
WAIT #1: nam='db file scattered read' ela= 43790 p1=186 p2=221113 p3=8
WAIT #1: nam='db file scattered read' ela= 9503 p1=187 p2=242921 p3=2
WAIT #1: nam='db file scattered read' ela= 29837 p1=185 p2=172514 p3=7
WAIT #1: nam='db file scattered read' ela= 25338 p1=186 p2=26265 p3=8
WAIT #1: nam='db file scattered read' ela= 36598 p1=187 p2=242945 p3=8
WAIT #1: nam='db file scattered read' ela= 26291 p1=186 p2=221121 p3=8
WAIT #1: nam='db file scattered read' ela= 6832 p1=187 p2=242961 p3=2
WAIT #1: nam='db file scattered read' ela= 29166 p1=185 p2=172522 p3=7
WAIT #1: nam='db file scattered read' ela= 30137 p1=186 p2=26273 p3=8
WAIT #1: nam='db file scattered read' ela= 29853 p1=187 p2=243073 p3=8
WAIT #1: nam='db file scattered read' ela= 26940 p1=186 p2=221145 p3=8
WAIT #1: nam='db file scattered read' ela= 22460 p1=187 p2=243217 p3=7
WAIT #1: nam='db file scattered read' ela= 26386 p1=185 p2=172530 p3=7
WAIT #1: nam='db file scattered read' ela= 28106 p1=186 p2=26281 p3=8
WAIT #1: nam='db file scattered read' ela= 25247 p1=187 p2=243417 p3=8
WAIT #1: nam='db file scattered read' ela= 15139 p1=186 p2=221153 p3=5
WAIT #1: nam='db file scattered read' ela= 19474 p1=185 p2=172538 p3=7
WAIT #1: nam='db file scattered read' ela= 26247 p1=186 p2=26289 p3=8
WAIT #1: nam='db file scattered read' ela= 25067 p1=187 p2=243441 p3=8
WAIT #1: nam='db file scattered read' ela= 25829 p1=186 p2=221161 p3=8
WAIT #1: nam='db file scattered read' ela= 8579 p1=187 p2=243449 p3=3
WAIT #1: nam='db file scattered read' ela= 20152 p1=185 p2=172546 p3=7
WAIT #1: nam='db file scattered read' ela= 24651 p1=186 p2=26297 p3=8
WAIT #1: nam='db file scattered read' ela= 24073 p1=187 p2=243457 p3=8
WAIT #1: nam='db file scattered read' ela= 25275 p1=186 p2=221169 p3=8
WAIT #1: nam='db file sequential read' ela= 3265 p1=187 p2=243721 p3=1
WAIT #1: nam='db file scattered read' ela= 21023 p1=185 p2=172970 p3=7
WAIT #1: nam='db file scattered read' ela= 21956 p1=186 p2=26305 p3=8
WAIT #1: nam='db file scattered read' ela= 21712 p1=187 p2=243737 p3=8
WAIT #1: nam='db file scattered read' ela= 22422 p1=186 p2=221177 p3=8
WAIT #1: nam='db file sequential read' ela= 2818 p1=187 p2=243745 p3=1
WAIT #1: nam='db file scattered read' ela= 19101 p1=185 p2=172986 p3=7
WAIT #1: nam='db file scattered read' ela= 19269 p1=186 p2=26313 p3=8
WAIT #1: nam='db file scattered read' ela= 23566 p1=187 p2=244841 p3=8
WAIT #1: nam='db file scattered read' ela= 42235 p1=186 p2=221185 p3=8
WAIT #1: nam='db file sequential read' ela= 5475 p1=187 p2=245777 p3=1
WAIT #1: nam='db file sequential read' ela= 29034 p1=185 p2=172993 p3=1
WAIT #1: nam='db file scattered read' ela= 44507 p1=185 p2=172994 p3=7
WAIT #1: nam='db file scattered read' ela= 44382 p1=186 p2=26393 p3=8
WAIT #1: nam='db file scattered read' ela= 31085 p1=187 p2=245785 p3=8
WAIT #1: nam='db file scattered read' ela= 25173 p1=186 p2=221201 p3=8
WAIT #1: nam='db file scattered read' ela= 8050 p1=187 p2=245793 p3=3
WAIT #1: nam='db file scattered read' ela= 18998 p1=185 p2=173514 p3=7
WAIT #1: nam='db file scattered read' ela= 22922 p1=186 p2=26713 p3=8
WAIT #1: nam='db file scattered read' ela= 23225 p1=187 p2=245801 p3=8
WAIT #1: nam='db file scattered read' ela= 24710 p1=186 p2=221217 p3=8
WAIT #1: nam='db file scattered read' ela= 11224 p1=187 p2=245817 p3=4
WAIT #1: nam='db file scattered read' ela= 20972 p1=185 p2=173522 p3=7
WAIT #1: nam='db file scattered read' ela= 22685 p1=186 p2=26721 p3=8
WAIT #1: nam='db file scattered read' ela= 22986 p1=187 p2=245825 p3=8
WAIT #1: nam='db file scattered read' ela= 22893 p1=186 p2=221225 p3=8
WAIT #1: nam='db file scattered read' ela= 8469 p1=187 p2=245857 p3=3
WAIT #1: nam='db file scattered read' ela= 22432 p1=185 p2=173658 p3=7
WAIT #1: nam='db file scattered read' ela= 25525 p1=186 p2=26729 p3=8
WAIT #1: nam='db file scattered read' ela= 23833 p1=187 p2=245865 p3=8
WAIT #1: nam='db file scattered read' ela= 23330 p1=186 p2=221241 p3=8
WAIT #1: nam='db file scattered read' ela= 6559 p1=187 p2=245881 p3=2
WAIT #1: nam='db file scattered read' ela= 20439 p1=185 p2=173666 p3=7
WAIT #1: nam='db file scattered read' ela= 21991 p1=186 p2=26737 p3=8
WAIT #1: nam='db file scattered read' ela= 24140 p1=187 p2=245889 p3=8
WAIT #1: nam='db file scattered read' ela= 24723 p1=186 p2=221249 p3=8
WAIT #1: nam='db file scattered read' ela= 5738 p1=187 p2=249537 p3=2
WAIT #1: nam='db file scattered read' ela= 19341 p1=185 p2=173674 p3=7
WAIT #1: nam='db file scattered read' ela= 22653 p1=186 p2=26745 p3=8
WAIT #1: nam='db file scattered read' ela= 22237 p1=187 p2=249545 p3=8
WAIT #1: nam='db file scattered read' ela= 23930 p1=186 p2=221257 p3=8
WAIT #1: nam='db file sequential read' ela= 4732 p1=187 p2=249553 p3=1
WAIT #1: nam='db file scattered read' ela= 22108 p1=185 p2=173682 p3=7
WAIT #1: nam='db file scattered read' ela= 23151 p1=186 p2=26753 p3=8
WAIT #1: nam='db file scattered read' ela= 25468 p1=187 p2=249577 p3=8
WAIT #1: nam='db file scattered read' ela= 22855 p1=186 p2=221281 p3=8
WAIT #1: nam='db file scattered read' ela= 11046 p1=187 p2=249585 p3=4
WAIT #1: nam='db file scattered read' ela= 17700 p1=185 p2=173690 p3=7
WAIT #1: nam='db file scattered read' ela= 23798 p1=186 p2=26969 p3=8
WAIT #1: nam='db file scattered read' ela= 21526 p1=187 p2=249593 p3=8
WAIT #1: nam='db file scattered read' ela= 21842 p1=186 p2=221305 p3=8
WAIT #1: nam='db file scattered read' ela= 5086 p1=187 p2=249601 p3=2
WAIT #1: nam='db file scattered read' ela= 19868 p1=185 p2=173698 p3=7
WAIT #1: nam='db file scattered read' ela= 22231 p1=186 p2=26985 p3=8
WAIT #1: nam='db file scattered read' ela= 20940 p1=187 p2=251793 p3=8
WAIT #1: nam='db file scattered read' ela= 21054 p1=186 p2=221313 p3=8
WAIT #1: nam='db file sequential read' ela= 2704 p1=187 p2=251801 p3=1
WAIT #1: nam='db file scattered read' ela= 19609 p1=185 p2=174474 p3=7
WAIT #1: nam='db file scattered read' ela= 39574 p1=186 p2=27001 p3=8
WAIT #1: nam='db file scattered read' ela= 21911 p1=187 p2=251809 p3=8
WAIT #1: nam='db file scattered read' ela= 22681 p1=186 p2=222089 p3=8
WAIT #1: nam='db file sequential read' ela= 2551 p1=187 p2=251817 p3=1
WAIT #1: nam='db file scattered read' ela= 19073 p1=185 p2=174482 p3=7
WAIT #1: nam='db file scattered read' ela= 21819 p1=186 p2=27401 p3=8
WAIT #1: nam='db file scattered read' ela= 23062 p1=187 p2=251825 p3=8
WAIT #1: nam='db file scattered read' ela= 22648 p1=186 p2=222097 p3=8
WAIT #1: nam='db file sequential read' ela= 2731 p1=187 p2=251833 p3=1
WAIT #1: nam='db file scattered read' ela= 18854 p1=185 p2=174490 p3=7
WAIT #1: nam='db file scattered read' ela= 22903 p1=186 p2=27409 p3=8
WAIT #1: nam='db file scattered read' ela= 21770 p1=187 p2=251857 p3=8
WAIT #1: nam='db file scattered read' ela= 21892 p1=186 p2=222105 p3=8
WAIT #1: nam='db file sequential read' ela= 2773 p1=187 p2=253201 p3=1
WAIT #1: nam='db file scattered read' ela= 20032 p1=185 p2=174506 p3=7
WAIT #1: nam='db file scattered read' ela= 20821 p1=186 p2=27417 p3=8
WAIT #1: nam='db file scattered read' ela= 21680 p1=187 p2=253209 p3=8
WAIT #1: nam='db file scattered read' ela= 21272 p1=186 p2=222113 p3=8
WAIT #1: nam='db file sequential read' ela= 2786 p1=187 p2=253217 p3=1
WAIT #1: nam='db file scattered read' ela= 20343 p1=185 p2=174522 p3=7
WAIT #1: nam='db file scattered read' ela= 23214 p1=186 p2=27425 p3=8
WAIT #1: nam='db file scattered read' ela= 21752 p1=187 p2=253225 p3=8
WAIT #1: nam='db file scattered read' ela= 21157 p1=186 p2=222121 p3=8
WAIT #1: nam='db file sequential read' ela= 2755 p1=187 p2=253241 p3=1
WAIT #1: nam='db file scattered read' ela= 18562 p1=185 p2=174530 p3=7
WAIT #1: nam='db file scattered read' ela= 21618 p1=186 p2=27433 p3=8
WAIT #1: nam='db file scattered read' ela= 21666 p1=187 p2=253249 p3=8
WAIT #1: nam='db file scattered read' ela= 20684 p1=186 p2=222129 p3=8
WAIT #1: nam='db file sequential read' ela= 2445 p1=187 p2=253265 p3=1
WAIT #1: nam='db file sequential read' ela= 18163 p1=185 p2=174537 p3=1
WAIT #1: nam='db file scattered read' ela= 18375 p1=185 p2=174538 p3=7
WAIT #1: nam='db file scattered read' ela= 21569 p1=186 p2=27441 p3=8
WAIT #1: nam='db file scattered read' ela= 21901 p1=187 p2=253273 p3=8
WAIT #1: nam='db file scattered read' ela= 20603 p1=186 p2=222137 p3=8
WAIT #1: nam='db file sequential read' ela= 2564 p1=187 p2=253281 p3=1
WAIT #1: nam='db file scattered read' ela= 18165 p1=185 p2=176010 p3=7
WAIT #1: nam='db file scattered read' ela= 20366 p1=186 p2=27449 p3=8
WAIT #1: nam='db file scattered read' ela= 20790 p1=187 p2=253289 p3=8
WAIT #1: nam='db file scattered read' ela= 21185 p1=186 p2=222145 p3=8
WAIT #1: nam='db file scattered read' ela= 7866 p1=187 p2=253297 p3=3
WAIT #1: nam='db file scattered read' ela= 18553 p1=185 p2=176018 p3=7
WAIT #1: nam='db file scattered read' ela= 20474 p1=186 p2=27457 p3=8
WAIT #1: nam='db file scattered read' ela= 21969 p1=187 p2=253313 p3=8
WAIT #1: nam='db file scattered read' ela= 22093 p1=186 p2=222153 p3=8
WAIT #1: nam='db file sequential read' ela= 3054 p1=187 p2=255497 p3=1
WAIT #1: nam='db file scattered read' ela= 18443 p1=185 p2=176026 p3=7
WAIT #1: nam='db file scattered read' ela= 21828 p1=186 p2=27465 p3=8
WAIT #1: nam='db file scattered read' ela= 21664 p1=187 p2=255505 p3=8
WAIT #1: nam='db file scattered read' ela= 22370 p1=186 p2=222161 p3=8
WAIT #1: nam='db file sequential read' ela= 2768 p1=187 p2=255513 p3=1
WAIT #1: nam='db file scattered read' ela= 17635 p1=185 p2=176034 p3=7
WAIT #1: nam='db file scattered read' ela= 21828 p1=186 p2=27473 p3=8
WAIT #1: nam='db file scattered read' ela= 20606 p1=187 p2=255521 p3=8
WAIT #1: nam='db file scattered read' ela= 22699 p1=186 p2=222169 p3=8
WAIT #1: nam='db file scattered read' ela= 9753 p1=187 p2=257409 p3=3
WAIT #1: nam='db file sequential read' ela= 17805 p1=185 p2=176041 p3=1
WAIT #1: nam='db file scattered read' ela= 19768 p1=185 p2=176042 p3=7
WAIT #1: nam='db file scattered read' ela= 22333 p1=186 p2=27481 p3=8
WAIT #1: nam='db file scattered read' ela= 22760 p1=187 p2=258329 p3=8
WAIT #1: nam='db file scattered read' ela= 22078 p1=186 p2=222177 p3=8
WAIT #1: nam='db file scattered read' ela= 5001 p1=187 p2=258337 p3=2
WAIT #1: nam='db file scattered read' ela= 18844 p1=185 p2=176050 p3=7
WAIT #1: nam='db file scattered read' ela= 21654 p1=186 p2=27489 p3=8
WAIT #1: nam='db file scattered read' ela= 21557 p1=187 p2=258345 p3=8
WAIT #1: nam='db file scattered read' ela= 21360 p1=186 p2=222185 p3=8
WAIT #1: nam='db file scattered read' ela= 7772 p1=187 p2=258353 p3=3
WAIT #1: nam='db file sequential read' ela= 24847 p1=185 p2=176057 p3=1
WAIT #1: nam='db file scattered read' ela= 20725 p1=185 p2=176058 p3=7
WAIT #1: nam='db file scattered read' ela= 37002 p1=186 p2=27497 p3=8
WAIT #1: nam='db file scattered read' ela= 20448 p1=187 p2=258361 p3=8
WAIT #1: nam='db file scattered read' ela= 21588 p1=186 p2=222193 p3=8
WAIT #1: nam='db file scattered read' ela= 21114 p1=187 p2=258369 p3=8
WAIT #1: nam='db file sequential read' ela= 2573 p1=186 p2=225969 p3=1
WAIT #1: nam='db file sequential read' ela= 20564 p1=185 p2=176065 p3=1
WAIT #1: nam='db file scattered read' ela= 18142 p1=185 p2=176066 p3=7
WAIT #1: nam='db file scattered read' ela= 21745 p1=186 p2=28049 p3=8
WAIT #1: nam='db file scattered read' ela= 21988 p1=187 p2=258385 p3=8
WAIT #1: nam='db file scattered read' ela= 21728 p1=186 p2=222201 p3=8
WAIT #1: nam='db file scattered read' ela= 8416 p1=187 p2=258393 p3=3
WAIT #1: nam='db file sequential read' ela= 21283 p1=185 p2=176073 p3=1
WAIT #1: nam='db file scattered read' ela= 18927 p1=185 p2=176074 p3=7
WAIT #1: nam='db file scattered read' ela= 21734 p1=186 p2=28089 p3=8
WAIT #1: nam='db file scattered read' ela= 21585 p1=187 p2=258401 p3=8
WAIT #1: nam='db file scattered read' ela= 20506 p1=186 p2=225953 p3=8
WAIT #1: nam='db file scattered read' ela= 12903 p1=187 p2=258409 p3=5
WAIT #1: nam='db file sequential read' ela= 20074 p1=185 p2=176081 p3=1
WAIT #1: nam='db file scattered read' ela= 18707 p1=185 p2=176082 p3=7
WAIT #1: nam='db file scattered read' ela= 20793 p1=186 p2=28121 p3=8
WAIT #1: nam='db file scattered read' ela= 21263 p1=187 p2=258417 p3=8
WAIT #1: nam='db file scattered read' ela= 21166 p1=186 p2=225961 p3=8
WAIT #1: nam='db file scattered read' ela= 16701 p1=187 p2=258425 p3=6
WAIT #1: nam='db file sequential read' ela= 19442 p1=185 p2=176089 p3=1
WAIT #1: nam='db file scattered read' ela= 18216 p1=185 p2=176090 p3=7
WAIT #1: nam='db file scattered read' ela= 20607 p1=186 p2=28681 p3=8
WAIT #1: nam='db file scattered read' ela= 20743 p1=187 p2=258433 p3=8
WAIT #1: nam='db file scattered read' ela= 23632 p1=186 p2=225985 p3=8
WAIT #1: nam='db file scattered read' ela= 22781 p1=187 p2=263353 p3=8
WAIT #1: nam='db file sequential read' ela= 33241 p1=185 p2=176097 p3=1
WAIT #1: nam='db file scattered read' ela= 21334 p1=185 p2=176098 p3=7
WAIT #1: nam='db file scattered read' ela= 23546 p1=186 p2=29065 p3=8
WAIT #1: nam='db file scattered read' ela= 21626 p1=187 p2=264793 p3=8
WAIT #1: nam='db file scattered read' ela= 20693 p1=186 p2=225993 p3=8
WAIT #1: nam='db file sequential read' ela= 2831 p1=187 p2=373809 p3=1
WAIT #1: nam='db file sequential read' ela= 3222 p1=185 p2=176105 p3=1
WAIT #1: nam='db file scattered read' ela= 17761 p1=185 p2=176106 p3=7
WAIT #1: nam='db file scattered read' ela= 22053 p1=186 p2=29113 p3=8
WAIT #1: nam='db file scattered read' ela= 21901 p1=187 p2=264801 p3=8
WAIT #1: nam='db file scattered read' ela= 20789 p1=186 p2=226001 p3=8
WAIT #1: nam='db file sequential read' ela= 2589 p1=187 p2=264809 p3=1
WAIT #1: nam='db file sequential read' ela= 21298 p1=185 p2=176113 p3=1
WAIT #1: nam='db file scattered read' ela= 19104 p1=185 p2=176114 p3=7
WAIT #1: nam='db file scattered read' ela= 21504 p1=186 p2=29121 p3=8
WAIT #1: nam='db file scattered read' ela= 20964 p1=187 p2=264825 p3=8
WAIT #1: nam='db file scattered read' ela= 22972 p1=186 p2=226009 p3=8
WAIT #1: nam='db file scattered read' ela= 16466 p1=187 p2=264833 p3=6
WAIT #1: nam='db file sequential read' ela= 3583 p1=185 p2=176129 p3=1
WAIT #1: nam='db file scattered read' ela= 18692 p1=185 p2=176130 p3=7
WAIT #1: nam='db file scattered read' ela= 22143 p1=186 p2=29129 p3=8
WAIT #1: nam='db file scattered read' ela= 20708 p1=187 p2=269737 p3=8
WAIT #1: nam='db file scattered read' ela= 21729 p1=186 p2=226017 p3=8
WAIT #1: nam='db file scattered read' ela= 8044 p1=187 p2=373801 p3=3
WAIT #1: nam='db file sequential read' ela= 19608 p1=185 p2=178257 p3=1
WAIT #1: nam='db file scattered read' ela= 18272 p1=185 p2=178258 p3=7
WAIT #1: nam='db file scattered read' ela= 19628 p1=186 p2=29137 p3=8
WAIT #1: nam='db file scattered read' ela= 20635 p1=187 p2=644913 p3=8
WAIT #1: nam='db file scattered read' ela= 18981 p1=186 p2=226025 p3=8
WAIT #1: nam='db file scattered read' ela= 9475 p1=187 p2=670369 p3=4
WAIT #1: nam='db file sequential read' ela= 11840 p1=185 p2=178289 p3=1
WAIT #1: nam='db file scattered read' ela= 17772 p1=185 p2=178290 p3=7
WAIT #1: nam='db file scattered read' ela= 19869 p1=186 p2=29145 p3=8
WAIT #1: nam='db file scattered read' ela= 20424 p1=187 p2=670441 p3=8
WAIT #1: nam='db file scattered read' ela= 21447 p1=186 p2=226041 p3=8
WAIT #1: nam='db file scattered read' ela= 9818 p1=187 p2=671401 p3=4
WAIT #1: nam='db file sequential read' ela= 22265 p1=185 p2=178721 p3=1
WAIT #1: nam='db file scattered read' ela= 19328 p1=185 p2=178722 p3=7
WAIT #1: nam='db file scattered read' ela= 21091 p1=186 p2=29153 p3=8
WAIT #1: nam='db file scattered read' ela= 21317 p1=187 p2=671409 p3=8
WAIT #1: nam='db file scattered read' ela= 21943 p1=186 p2=226209 p3=8
WAIT #1: nam='db file scattered read' ela= 6512 p1=187 p2=671433 p3=2
WAIT #1: nam='db file sequential read' ela= 19711 p1=185 p2=178729 p3=1
WAIT #1: nam='db file scattered read' ela= 18878 p1=185 p2=178730 p3=7
WAIT #1: nam='db file scattered read' ela= 20609 p1=186 p2=29161 p3=8
WAIT #1: nam='db file scattered read' ela= 21256 p1=187 p2=671441 p3=8
WAIT #1: nam='db file scattered read' ela= 22218 p1=186 p2=226241 p3=8
WAIT #1: nam='db file sequential read' ela= 2577 p1=187 p2=671473 p3=1
WAIT #1: nam='db file sequential read' ela= 3025 p1=185 p2=178737 p3=1
WAIT #1: nam='db file scattered read' ela= 19023 p1=185 p2=178738 p3=7
WAIT #1: nam='db file scattered read' ela= 22630 p1=186 p2=29169 p3=8
WAIT #1: nam='db file scattered read' ela= 22693 p1=187 p2=671481 p3=8
WAIT #1: nam='db file scattered read' ela= 20967 p1=186 p2=226361 p3=8
WAIT #1: nam='db file scattered read' ela= 8783 p1=187 p2=676873 p3=3
WAIT #1: nam='db file scattered read' ela= 18803 p1=185 p2=178746 p3=7
WAIT #1: nam='db file scattered read' ela= 23924 p1=186 p2=29201 p3=8
WAIT #1: nam='db file scattered read' ela= 21546 p1=187 p2=676881 p3=8
WAIT #1: nam='db file scattered read' ela= 20817 p1=186 p2=226401 p3=8
WAIT #1: nam='db file sequential read' ela= 2416 p1=187 p2=676897 p3=1
WAIT #1: nam='db file sequential read' ela= 19263 p1=185 p2=178753 p3=1
WAIT #1: nam='db file scattered read' ela= 19535 p1=185 p2=178754 p3=7
WAIT #1: nam='db file scattered read' ela= 20479 p1=186 p2=29209 p3=8
WAIT #1: nam='db file scattered read' ela= 22094 p1=187 p2=676905 p3=8
WAIT #1: nam='db file scattered read' ela= 22471 p1=186 p2=226433 p3=8
WAIT #1: nam='db file sequential read' ela= 2949 p1=187 p2=676929 p3=1
WAIT #1: nam='db file scattered read' ela= 20368 p1=185 p2=178762 p3=7
WAIT #1: nam='db file scattered read' ela= 22454 p1=186 p2=29217 p3=8
WAIT #1: nam='db file scattered read' ela= 25149 p1=187 p2=681609 p3=8
WAIT #1: nam='db file scattered read' ela= 22434 p1=186 p2=227081 p3=8
WAIT #1: nam='db file sequential read' ela= 3260 p1=187 p2=681617 p3=1
WAIT #1: nam='db file scattered read' ela= 19540 p1=185 p2=178770 p3=7
WAIT #1: nam='db file scattered read' ela= 24592 p1=186 p2=29225 p3=8
WAIT #1: nam='db file scattered read' ela= 22356 p1=187 p2=681625 p3=8
WAIT #1: nam='db file scattered read' ela= 20399 p1=186 p2=227089 p3=8
WAIT #1: nam='db file sequential read' ela= 2966 p1=187 p2=681641 p3=1
WAIT #1: nam='db file scattered read' ela= 18494 p1=185 p2=178786 p3=7
WAIT #1: nam='db file scattered read' ela= 22804 p1=186 p2=29233 p3=8
WAIT #1: nam='db file scattered read' ela= 23025 p1=187 p2=681649 p3=8
WAIT #1: nam='db file scattered read' ela= 21292 p1=186 p2=227097 p3=8
WAIT #1: nam='db file scattered read' ela= 12322 p1=187 p2=681673 p3=4
WAIT #1: nam='db file sequential read' ela= 3462 p1=185 p2=178793 p3=1
WAIT #1: nam='db file scattered read' ela= 18129 p1=185 p2=178794 p3=7
WAIT #1: nam='db file scattered read' ela= 21308 p1=186 p2=29241 p3=8
WAIT #1: nam='db file scattered read' ela= 20906 p1=187 p2=681681 p3=8
WAIT #1: nam='db file scattered read' ela= 22867 p1=186 p2=227137 p3=8
WAIT #1: nam='db file scattered read' ela= 5894 p1=187 p2=681689 p3=2
WAIT #1: nam='db file scattered read' ela= 18474 p1=185 p2=178802 p3=7
WAIT #1: nam='db file scattered read' ela= 22266 p1=186 p2=29249 p3=8
WAIT #1: nam='db file scattered read' ela= 20497 p1=187 p2=681697 p3=8
WAIT #1: nam='db file scattered read' ela= 21694 p1=186 p2=227145 p3=8
WAIT #1: nam='db file scattered read' ela= 19735 p1=185 p2=178818 p3=7
WAIT #1: nam='db file scattered read' ela= 21987 p1=186 p2=29257 p3=8
WAIT #1: nam='db file scattered read' ela= 21347 p1=187 p2=681705 p3=8
WAIT #1: nam='db file scattered read' ela= 21665 p1=186 p2=227153 p3=8
WAIT #1: nam='db file scattered read' ela= 11006 p1=187 p2=681713 p3=4
WAIT #1: nam='db file scattered read' ela= 21348 p1=185 p2=178874 p3=7
WAIT #1: nam='db file scattered read' ela= 22229 p1=186 p2=29265 p3=8
WAIT #1: nam='db file scattered read' ela= 21579 p1=187 p2=719969 p3=8
WAIT #1: nam='db file scattered read' ela= 22586 p1=186 p2=227161 p3=8
WAIT #1: nam='db file sequential read' ela= 2550 p1=187 p2=719977 p3=1
WAIT #1: nam='db file scattered read' ela= 19816 p1=185 p2=178890 p3=7
WAIT #1: nam='db file scattered read' ela= 20868 p1=186 p2=29273 p3=8
WAIT #1: nam='db file scattered read' ela= 19950 p1=187 p2=719985 p3=8
WAIT #1: nam='db file scattered read' ela= 21686 p1=186 p2=227169 p3=8
WAIT #1: nam='db file sequential read' ela= 2638 p1=187 p2=719993 p3=1
WAIT #1: nam='db file scattered read' ela= 18527 p1=185 p2=178898 p3=7
WAIT #1: nam='db file scattered read' ela= 22675 p1=186 p2=29281 p3=8
WAIT #1: nam='db file scattered read' ela= 22906 p1=187 p2=722321 p3=8
WAIT #1: nam='db file scattered read' ela= 24037 p1=186 p2=227177 p3=8
WAIT #1: nam='db file scattered read' ela= 8636 p1=187 p2=722345 p3=3
WAIT #1: nam='db file scattered read' ela= 18520 p1=185 p2=179122 p3=7
WAIT #1: nam='db file scattered read' ela= 20903 p1=186 p2=29289 p3=8
WAIT #1: nam='db file scattered read' ela= 23351 p1=187 p2=722353 p3=8
WAIT #1: nam='db file scattered read' ela= 22480 p1=186 p2=227185 p3=8
WAIT #1: nam='db file scattered read' ela= 5511 p1=187 p2=722377 p3=2
WAIT #1: nam='db file scattered read' ela= 18641 p1=185 p2=180018 p3=7
WAIT #1: nam='db file scattered read' ela= 21474 p1=186 p2=29297 p3=8
WAIT #1: nam='db file scattered read' ela= 21017 p1=187 p2=722385 p3=8
WAIT #1: nam='db file scattered read' ela= 21804 p1=186 p2=227193 p3=8
WAIT #1: nam='db file scattered read' ela= 5292 p1=187 p2=722425 p3=2
WAIT #1: nam='db file scattered read' ela= 18619 p1=185 p2=180050 p3=7
WAIT #1: nam='db file scattered read' ela= 21547 p1=186 p2=29305 p3=8
WAIT #1: nam='db file scattered read' ela= 20110 p1=187 p2=722433 p3=8
WAIT #1: nam='db file scattered read' ela= 21339 p1=186 p2=227201 p3=8
WAIT #1: nam='db file scattered read' ela= 7920 p1=187 p2=723993 p3=3
WAIT #1: nam='db file scattered read' ela= 19142 p1=185 p2=180082 p3=7
WAIT #1: nam='db file scattered read' ela= 21531 p1=186 p2=29313 p3=8
WAIT #1: nam='db file scattered read' ela= 20874 p1=187 p2=724001 p3=8
WAIT #1: nam='db file scattered read' ela= 23736 p1=186 p2=227473 p3=8
WAIT #1: nam='db file sequential read' ela= 2932 p1=187 p2=724017 p3=1
WAIT #1: nam='db file scattered read' ela= 20906 p1=185 p2=181074 p3=7
WAIT #1: nam='db file scattered read' ela= 29202 p1=186 p2=29705 p3=8
WAIT #1: nam='db file scattered read' ela= 21986 p1=187 p2=724025 p3=8
WAIT #1: nam='db file scattered read' ela= 21426 p1=186 p2=227481 p3=8
WAIT #1: nam='db file scattered read' ela= 7601 p1=187 p2=724041 p3=3
WAIT #1: nam='db file scattered read' ela= 21094 p1=185 p2=181082 p3=7
WAIT #1: nam='db file scattered read' ela= 22806 p1=186 p2=29961 p3=8
WAIT #1: nam='db file scattered read' ela= 24706 p1=187 p2=724049 p3=8
WAIT #1: nam='db file scattered read' ela= 22156 p1=186 p2=227489 p3=8
WAIT #1: nam='db file scattered read' ela= 9544 p1=187 p2=724073 p3=3
WAIT #1: nam='db file scattered read' ela= 19944 p1=185 p2=181114 p3=7
WAIT #1: nam='db file scattered read' ela= 22231 p1=186 p2=29969 p3=8
WAIT #1: nam='db file scattered read' ela= 22596 p1=187 p2=724081 p3=8
WAIT #1: nam='db file scattered read' ela= 20663 p1=186 p2=227497 p3=8
WAIT #1: nam='db file scattered read' ela= 8525 p1=187 p2=730249 p3=3
WAIT #1: nam='db file scattered read' ela= 19716 p1=185 p2=181122 p3=7
WAIT #1: nam='db file scattered read' ela= 21870 p1=186 p2=29977 p3=8
WAIT #1: nam='db file scattered read' ela= 19828 p1=187 p2=730265 p3=8
WAIT #1: nam='db file scattered read' ela= 21070 p1=186 p2=227505 p3=8
WAIT #1: nam='db file scattered read' ela= 8107 p1=187 p2=730273 p3=3
WAIT #1: nam='db file scattered read' ela= 18912 p1=185 p2=181210 p3=7
WAIT #1: nam='db file scattered read' ela= 21341 p1=186 p2=29985 p3=8
WAIT #1: nam='db file scattered read' ela= 21505 p1=187 p2=730281 p3=8
WAIT #1: nam='db file scattered read' ela= 20901 p1=186 p2=227513 p3=8
WAIT #1: nam='db file sequential read' ela= 3366 p1=187 p2=730297 p3=1
WAIT #1: nam='db file scattered read' ela= 18652 p1=185 p2=181362 p3=7
WAIT #1: nam='db file scattered read' ela= 21925 p1=186 p2=29993 p3=8
WAIT #1: nam='db file scattered read' ela= 22943 p1=187 p2=730305 p3=8
WAIT #1: nam='db file scattered read' ela= 20150 p1=186 p2=227521 p3=8
WAIT #1: nam='db file scattered read' ela= 5152 p1=187 p2=730321 p3=2
WAIT #1: nam='db file scattered read' ela= 18310 p1=185 p2=181370 p3=7
WAIT #1: nam='db file scattered read' ela= 22261 p1=186 p2=30057 p3=8
WAIT #1: nam='db file scattered read' ela= 22336 p1=187 p2=730353 p3=8
WAIT #1: nam='db file scattered read' ela= 22893 p1=186 p2=227537 p3=8
WAIT #1: nam='db file scattered read' ela= 5864 p1=187 p2=730369 p3=2
WAIT #1: nam='db file scattered read' ela= 20514 p1=185 p2=181378 p3=7
WAIT #1: nam='db file scattered read' ela= 20987 p1=186 p2=30065 p3=8
WAIT #1: nam='db file scattered read' ela= 23647 p1=187 p2=730377 p3=8
WAIT #1: nam='db file scattered read' ela= 22365 p1=186 p2=227545 p3=8
WAIT #1: nam='db file scattered read' ela= 12187 p1=187 p2=730417 p3=4
WAIT #1: nam='db file scattered read' ela= 17611 p1=185 p2=181794 p3=7
WAIT #1: nam='db file scattered read' ela= 20954 p1=186 p2=30073 p3=8
WAIT #1: nam='db file scattered read' ela= 23170 p1=187 p2=730449 p3=8
WAIT #1: nam='db file scattered read' ela= 23832 p1=186 p2=227553 p3=8
WAIT #1: nam='db file scattered read' ela= 7241 p1=187 p2=730465 p3=3
WAIT #1: nam='db file sequential read' ela= 2872 p1=185 p2=181897 p3=1
WAIT #1: nam='db file scattered read' ela= 18951 p1=185 p2=181898 p3=7
WAIT #1: nam='db file scattered read' ela= 21912 p1=186 p2=30081 p3=8
WAIT #1: nam='db file scattered read' ela= 20684 p1=187 p2=730473 p3=8
WAIT #1: nam='db file scattered read' ela= 21956 p1=186 p2=227569 p3=8
WAIT #1: nam='db file scattered read' ela= 15481 p1=187 p2=730481 p3=6
WAIT #1: nam='db file scattered read' ela= 18860 p1=185 p2=181906 p3=7
WAIT #1: nam='db file scattered read' ela= 22183 p1=186 p2=31865 p3=8
WAIT #1: nam='db file scattered read' ela= 21975 p1=187 p2=732689 p3=8
WAIT #1: nam='db file scattered read' ela= 22106 p1=186 p2=227577 p3=8
WAIT #1: nam='db file scattered read' ela= 5275 p1=187 p2=732697 p3=2
WAIT #1: nam='db file scattered read' ela= 19480 p1=185 p2=181914 p3=7
WAIT #1: nam='db file scattered read' ela= 20810 p1=186 p2=31873 p3=8
WAIT #1: nam='db file scattered read' ela= 22303 p1=187 p2=732705 p3=8
WAIT #1: nam='db file scattered read' ela= 22383 p1=186 p2=227617 p3=8
WAIT #1: nam='db file scattered read' ela= 5700 p1=187 p2=732713 p3=2
WAIT #1: nam='db file scattered read' ela= 17711 p1=185 p2=181922 p3=7
WAIT #1: nam='db file scattered read' ela= 22283 p1=186 p2=35977 p3=8
WAIT #1: nam='db file scattered read' ela= 23084 p1=187 p2=732721 p3=8
WAIT #1: nam='db file scattered read' ela= 21136 p1=186 p2=227625 p3=8
WAIT #1: nam='db file scattered read' ela= 10314 p1=187 p2=732737 p3=4
WAIT #1: nam='db file sequential read' ela= 19824 p1=185 p2=181929 p3=1
WAIT #1: nam='db file scattered read' ela= 19970 p1=185 p2=181930 p3=7
WAIT #1: nam='db file scattered read' ela= 21287 p1=186 p2=35985 p3=8
WAIT #1: nam='db file scattered read' ela= 21484 p1=187 p2=732745 p3=8
WAIT #1: nam='db file scattered read' ela= 20681 p1=186 p2=227633 p3=8
WAIT #1: nam='db file scattered read' ela= 5741 p1=187 p2=732753 p3=2
WAIT #1: nam='db file sequential read' ela= 21093 p1=185 p2=181937 p3=1
WAIT #1: nam='db file scattered read' ela= 16496 p1=185 p2=181938 p3=7
WAIT #1: nam='db file scattered read' ela= 22052 p1=186 p2=37001 p3=8
WAIT #1: nam='db file scattered read' ela= 20005 p1=187 p2=744073 p3=8
WAIT #1: nam='db file scattered read' ela= 21803 p1=186 p2=227689 p3=8
WAIT #1: nam='db file scattered read' ela= 5623 p1=187 p2=759425 p3=2
WAIT #1: nam='db file scattered read' ela= 18434 p1=185 p2=181946 p3=7
WAIT #1: nam='db file scattered read' ela= 20710 p1=186 p2=37009 p3=8
WAIT #1: nam='db file scattered read' ela= 22867 p1=187 p2=761617 p3=8
WAIT #1: nam='db file scattered read' ela= 20778 p1=186 p2=227721 p3=8
WAIT #1: nam='db file scattered read' ela= 8698 p1=187 p2=761665 p3=3
WAIT #1: nam='db file scattered read' ela= 18792 p1=185 p2=181970 p3=7
WAIT #1: nam='db file scattered read' ela= 22231 p1=186 p2=37017 p3=8
WAIT #1: nam='db file scattered read' ela= 24275 p1=187 p2=761705 p3=8
WAIT #1: nam='db file scattered read' ela= 24259 p1=186 p2=227729 p3=8
WAIT #1: nam='db file sequential read' ela= 2556 p1=187 p2=761729 p3=1
WAIT #1: nam='db file scattered read' ela= 19996 p1=185 p2=182226 p3=7
WAIT #1: nam='db file scattered read' ela= 20742 p1=186 p2=37025 p3=8
WAIT #1: nam='db file scattered read' ela= 21186 p1=187 p2=764937 p3=8
WAIT #1: nam='db file scattered read' ela= 20750 p1=186 p2=227737 p3=8
WAIT #1: nam='db file scattered read' ela= 7984 p1=187 p2=764945 p3=3
WAIT #1: nam='db file scattered read' ela= 18476 p1=185 p2=182234 p3=7
WAIT #1: nam='db file scattered read' ela= 21515 p1=186 p2=37033 p3=8
WAIT #1: nam='db file scattered read' ela= 22176 p1=187 p2=764953 p3=8
WAIT #1: nam='db file scattered read' ela= 23050 p1=186 p2=227745 p3=8
WAIT #1: nam='db file scattered read' ela= 10230 p1=187 p2=764969 p3=4
WAIT #1: nam='db file scattered read' ela= 19663 p1=185 p2=182242 p3=7
WAIT #1: nam='db file scattered read' ela= 20995 p1=186 p2=37041 p3=8
WAIT #1: nam='db file scattered read' ela= 20927 p1=187 p2=764977 p3=8
WAIT #1: nam='db file scattered read' ela= 22970 p1=186 p2=227753 p3=8
WAIT #1: nam='db file scattered read' ela= 5112 p1=187 p2=764985 p3=2
WAIT #1: nam='db file scattered read' ela= 18374 p1=185 p2=182250 p3=7
WAIT #1: nam='db file scattered read' ela= 20731 p1=186 p2=37049 p3=8
WAIT #1: nam='db file scattered read' ela= 20745 p1=187 p2=764993 p3=8
WAIT #1: nam='db file scattered read' ela= 20866 p1=186 p2=227833 p3=8
WAIT #1: nam='db file scattered read' ela= 6305 p1=187 p2=765009 p3=2
WAIT #1: nam='db file scattered read' ela= 18791 p1=185 p2=182258 p3=7
WAIT #1: nam='db file scattered read' ela= 20764 p1=186 p2=37057 p3=8
WAIT #1: nam='db file scattered read' ela= 21189 p1=187 p2=765017 p3=8
WAIT #1: nam='db file scattered read' ela= 21337 p1=186 p2=227841 p3=8
WAIT #1: nam='db file scattered read' ela= 5153 p1=187 p2=765025 p3=2
WAIT #1: nam='db file scattered read' ela= 18204 p1=185 p2=182370 p3=7
WAIT #1: nam='db file scattered read' ela= 21991 p1=186 p2=37065 p3=8
WAIT #1: nam='db file scattered read' ela= 23482 p1=187 p2=765033 p3=8
WAIT #1: nam='db file scattered read' ela= 23458 p1=186 p2=227849 p3=8
WAIT #1: nam='db file scattered read' ela= 6727 p1=187 p2=765041 p3=2
WAIT #1: nam='db file scattered read' ela= 19617 p1=185 p2=182378 p3=7
WAIT #1: nam='db file scattered read' ela= 21956 p1=186 p2=37073 p3=8
WAIT #1: nam='db file scattered read' ela= 20916 p1=187 p2=765049 p3=8
WAIT #1: nam='db file scattered read' ela= 22293 p1=186 p2=227945 p3=8
WAIT #1: nam='db file scattered read' ela= 7310 p1=187 p2=765057 p3=3
WAIT #1: nam='db file scattered read' ela= 19025 p1=185 p2=182394 p3=7
WAIT #1: nam='db file scattered read' ela= 20725 p1=186 p2=37081 p3=8
WAIT #1: nam='db file scattered read' ela= 21316 p1=187 p2=865289 p3=8
WAIT #1: nam='db file scattered read' ela= 22243 p1=186 p2=227953 p3=8
WAIT #1: nam='db file sequential read' ela= 2630 p1=187 p2=865313 p3=1
WAIT #1: nam='db file scattered read' ela= 18728 p1=185 p2=182666 p3=7
WAIT #1: nam='db file scattered read' ela= 21017 p1=186 p2=37089 p3=8
WAIT #1: nam='db file scattered read' ela= 21609 p1=187 p2=865337 p3=8
WAIT #1: nam='db file scattered read' ela= 19652 p1=186 p2=227961 p3=8
WAIT #1: nam='db file sequential read' ela= 2626 p1=187 p2=865345 p3=1
WAIT #1: nam='db file scattered read' ela= 16951 p1=185 p2=202 p3=7
WAIT #1: nam='db file scattered read' ela= 22894 p1=186 p2=10137 p3=8
WAIT #1: nam='db file scattered read' ela= 20467 p1=187 p2=865361 p3=8
WAIT #1: nam='db file scattered read' ela= 21923 p1=186 p2=255121 p3=8
WAIT #1: nam='db file sequential read' ela= 2892 p1=187 p2=865369 p3=1
WAIT #1: nam='db file scattered read' ela= 17631 p1=185 p2=3346 p3=7
WAIT #1: nam='db file scattered read' ela= 20959 p1=186 p2=10145 p3=8
WAIT #1: nam='db file scattered read' ela= 21186 p1=187 p2=865385 p3=8
WAIT #1: nam='db file scattered read' ela= 20804 p1=186 p2=612545 p3=8
WAIT #1: nam='db file scattered read' ela= 11155 p1=187 p2=865401 p3=4
WAIT #1: nam='db file scattered read' ela= 17885 p1=185 p2=3370 p3=7
WAIT #1: nam='db file scattered read' ela= 21114 p1=186 p2=10153 p3=8
WAIT #1: nam='db file scattered read' ela= 20887 p1=187 p2=869513 p3=8
WAIT #1: nam='db file scattered read' ela= 22281 p1=186 p2=612553 p3=8
WAIT #1: nam='db file scattered read' ela= 9537 p1=187 p2=869529 p3=3
WAIT #1: nam='db file scattered read' ela= 19056 p1=185 p2=3378 p3=7
WAIT #1: nam='db file scattered read' ela= 21885 p1=186 p2=10177 p3=8
WAIT #1: nam='db file scattered read' ela= 21017 p1=187 p2=882097 p3=8
WAIT #1: nam='db file scattered read' ela= 22345 p1=187 p2=882105 p3=8
WAIT #1: nam='db file scattered read' ela= 10025 p1=187 p2=882121 p3=4
WAIT #1: nam='db file scattered read' ela= 18282 p1=185 p2=3386 p3=7
WAIT #1: nam='db file scattered read' ela= 21967 p1=186 p2=10185 p3=8
WAIT #1: nam='db file scattered read' ela= 22761 p1=187 p2=882129 p3=8
WAIT #1: nam='db file scattered read' ela= 20256 p1=187 p2=882137 p3=8
WAIT #1: nam='db file scattered read' ela= 5388 p1=187 p2=882145 p3=2
WAIT #1: nam='db file scattered read' ela= 18911 p1=185 p2=3394 p3=7
WAIT #1: nam='db file scattered read' ela= 21290 p1=186 p2=10193 p3=8
WAIT #1: nam='db file scattered read' ela= 21489 p1=187 p2=882153 p3=8
WAIT #1: nam='db file scattered read' ela= 24006 p1=187 p2=882161 p3=8
WAIT #1: nam='db file scattered read' ela= 5000 p1=187 p2=882169 p3=2
WAIT #1: nam='db file scattered read' ela= 17789 p1=185 p2=3546 p3=7
WAIT #1: nam='db file scattered read' ela= 21101 p1=186 p2=10201 p3=8
WAIT #1: nam='db file scattered read' ela= 21652 p1=187 p2=882177 p3=8
WAIT #1: nam='db file scattered read' ela= 21645 p1=187 p2=882337 p3=8
WAIT #1: nam='db file sequential read' ela= 2566 p1=187 p2=882353 p3=1
WAIT #1: nam='db file sequential read' ela= 2840 p1=185 p2=3561 p3=1
WAIT #1: nam='db file scattered read' ela= 18490 p1=185 p2=3562 p3=7
WAIT #1: nam='db file scattered read' ela= 20621 p1=186 p2=10225 p3=8
WAIT #1: nam='db file scattered read' ela= 20946 p1=187 p2=882361 p3=8
WAIT #1: nam='db file scattered read' ela= 21405 p1=187 p2=882369 p3=8
WAIT #1: nam='db file scattered read' ela= 7643 p1=187 p2=882377 p3=3
WAIT #1: nam='db file scattered read' ela= 19710 p1=185 p2=3570 p3=7
WAIT #1: nam='db file scattered read' ela= 21324 p1=186 p2=10233 p3=8
WAIT #1: nam='db file scattered read' ela= 23337 p1=187 p2=882385 p3=8
WAIT #1: nam='db file scattered read' ela= 24269 p1=187 p2=882393 p3=8
WAIT #1: nam='db file scattered read' ela= 24807 p1=187 p2=882401 p3=8
WAIT #1: nam='db file scattered read' ela= 19048 p1=185 p2=3578 p3=7
WAIT #1: nam='db file scattered read' ela= 21462 p1=186 p2=10969 p3=8
WAIT #1: nam='db file scattered read' ela= 26247 p1=187 p2=882409 p3=8
WAIT #1: nam='db file scattered read' ela= 21587 p1=187 p2=882417 p3=8
WAIT #1: nam='db file scattered read' ela= 7921 p1=187 p2=882425 p3=3
WAIT #1: nam='db file sequential read' ela= 2971 p1=185 p2=3585 p3=1
WAIT #1: nam='db file scattered read' ela= 18214 p1=185 p2=3586 p3=7
WAIT #1: nam='db file scattered read' ela= 21433 p1=186 p2=11841 p3=8
WAIT #1: nam='db file scattered read' ela= 20561 p1=187 p2=1012425 p3=8
WAIT #1: nam='db file scattered read' ela= 21784 p1=187 p2=1048561 p3=8
WAIT #1: nam='db file scattered read' ela= 11633 p1=435 p2=55817 p3=4
WAIT #1: nam='db file sequential read' ela= 3072 p1=185 p2=3665 p3=1
WAIT #1: nam='db file scattered read' ela= 26956 p1=185 p2=3666 p3=7
WAIT #1: nam='db file scattered read' ela= 27818 p1=186 p2=12169 p3=8
WAIT #1: nam='db file scattered read' ela= 32754 p1=435 p2=55825 p3=8
WAIT #1: nam='db file scattered read' ela= 22224 p1=435 p2=55833 p3=8
WAIT #1: nam='db file scattered read' ela= 7361 p1=435 p2=55841 p3=2
WAIT #1: nam='db file sequential read' ela= 3177 p1=185 p2=4001 p3=1
WAIT #1: nam='db file scattered read' ela= 30793 p1=185 p2=4002 p3=7
WAIT #1: nam='db file scattered read' ela= 36795 p1=186 p2=12177 p3=8
WAIT #1: nam='db file scattered read' ela= 34050 p1=435 p2=55849 p3=8
WAIT #1: nam='db file scattered read' ela= 26107 p1=435 p2=55857 p3=8
WAIT #1: nam='db file scattered read' ela= 26986 p1=185 p2=4010 p3=7
WAIT #1: nam='db file scattered read' ela= 31120 p1=186 p2=12185 p3=8
WAIT #1: nam='db file scattered read' ela= 35037 p1=435 p2=55865 p3=8
WAIT #1: nam='db file scattered read' ela= 26417 p1=435 p2=55873 p3=6
WAIT #1: nam='db file scattered read' ela= 32462 p1=185 p2=4018 p3=7
WAIT #1: nam='db file scattered read' ela= 40081 p1=186 p2=12193 p3=8
WAIT #1: nam='db file scattered read' ela= 32870 p1=435 p2=55881 p3=8
WAIT #1: nam='db file scattered read' ela= 40973 p1=435 p2=55889 p3=8
WAIT #1: nam='db file sequential read' ela= 19325 p1=435 p2=55897 p3=1
WAIT #1: nam='db file scattered read' ela= 35140 p1=185 p2=4026 p3=7
WAIT #1: nam='db file scattered read' ela= 23608 p1=186 p2=12217 p3=8
WAIT #1: nam='db file scattered read' ela= 25225 p1=435 p2=55905 p3=8
WAIT #1: nam='db file scattered read' ela= 21800 p1=435 p2=55913 p3=8
WAIT #1: nam='db file scattered read' ela= 19941 p1=185 p2=4034 p3=7
WAIT #1: nam='db file scattered read' ela= 20926 p1=186 p2=12225 p3=8
WAIT #1: nam='db file scattered read' ela= 21831 p1=435 p2=55921 p3=8
WAIT #1: nam='db file scattered read' ela= 24519 p1=435 p2=55929 p3=8
WAIT #1: nam='db file sequential read' ela= 2750 p1=435 p2=55937 p3=1
WAIT #1: nam='db file scattered read' ela= 18459 p1=185 p2=4042 p3=7
WAIT #1: nam='db file scattered read' ela= 22471 p1=186 p2=12233 p3=8
WAIT #1: nam='db file scattered read' ela= 23045 p1=435 p2=55945 p3=8
WAIT #1: nam='db file scattered read' ela= 23528 p1=435 p2=55953 p3=8
WAIT #1: nam='db file scattered read' ela= 18931 p1=185 p2=4050 p3=7
WAIT #1: nam='db file scattered read' ela= 33185 p1=186 p2=12241 p3=7
FETCH #1:c=14000000,e=16494857,p=4876,cr=5390,cu=9,mis=0,r=1,dep=0,og=4,tim=7902864634576

Continuing past the first fetch call

WAIT #1: nam='SQL*Net message from client' ela= 1556 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 6 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=226,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864636898 WAIT #1: nam='SQL*Net message from client' ela= 2744 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=212,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864640111 WAIT #1: nam='SQL*Net message from client' ela= 1707 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=203,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864642248 WAIT #1: nam='SQL*Net message from client' ela= 2361 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 7 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=265,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864645199 WAIT #1: nam='SQL*Net message from client' ela= 1875 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 5 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=233,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864647647 WAIT #1: nam='SQL*Net message from client' ela= 1836 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=203,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864650000 WAIT #1: nam='SQL*Net message from client' ela= 1832 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864652268 WAIT #1: nam='SQL*Net message from client' ela= 1663 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864654355 WAIT #1: nam='SQL*Net message from client' ela= 1722 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=207,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864656518 WAIT #1: nam='SQL*Net message from client' ela= 1945 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=205,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864659141 WAIT #1: nam='SQL*Net message from client' ela= 1719 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864661298 WAIT #1: nam='SQL*Net message from client' ela= 1740 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=203,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864663464 WAIT #1: nam='SQL*Net message from client' ela= 1841 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=203,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864665733 WAIT #1: nam='SQL*Net message from client' ela= 1757 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=202,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864667916 WAIT #1: nam='SQL*Net message from client' ela= 1914 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=206,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864670465 WAIT #1: nam='SQL*Net message from client' ela= 1709 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=207,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864672607 WAIT #1: nam='SQL*Net message from client' ela= 1636 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864674671 WAIT #1: nam='SQL*Net message from client' ela= 1785 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=249,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864676922 WAIT #1: nam='SQL*Net message from client' ela= 1794 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=253,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864679194 WAIT #1: nam='SQL*Net message from client' ela= 1636 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=204,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864681319 WAIT #1: nam='SQL*Net message from client' ela= 2156 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 5 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=237,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864684000 WAIT #1: nam='SQL*Net message from client' ela= 1677 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=207,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864686142 WAIT #1: nam='SQL*Net message from client' ela= 1753 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=208,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864688341 WAIT #1: nam='SQL*Net message from client' ela= 1790 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=202,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864690641 WAIT #1: nam='SQL*Net message from client' ela= 1668 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=207,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864692744 WAIT #1: nam='SQL*Net message from client' ela= 1771 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 6 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=238,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864695060 WAIT #1: nam='SQL*Net message from client' ela= 1961 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1650815232 p2=1 p3=0 FETCH #1:c=10000,e=301,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864697575 WAIT #1: nam='SQL*Net message from client' ela= 1651 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 5 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=208,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864699662 WAIT #1: nam='SQL*Net message from client' ela= 1841 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=207,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864702014 WAIT #1: nam='SQL*Net message from client' ela= 1731 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=202,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864704176 WAIT #1: nam='SQL*Net message from client' ela= 1732 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=208,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864706349 WAIT #1: nam='SQL*Net message from client' ela= 1959 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 5 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=209,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864708746 WAIT #1: nam='SQL*Net message from client' ela= 1837 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=262,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864711081 WAIT #1: nam='SQL*Net message from client' ela= 1740 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=206,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864713259 WAIT #1: nam='SQL*Net message from client' ela= 1826 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=206,p=0,cr=0,cu=0,mis=0,r=15,dep=0,og=4,tim=7902864715514 WAIT #1: nam='SQL*Net message from client' ela= 1829 p1=1650815232 p2=1 p3=0 WAIT #1: nam='SQL*Net message to client' ela= 4 p1=1650815232 p2=1 p3=0 FETCH #1:c=0,e=266,p=0,cr=0,cu=0,mis=0,r=12,dep=0,og=4,tim=7902864717839

WAIT #1: nam='SQL*Net message from client' ela= 2640 p1=1650815232 p2=1 p3=0
STAT #1 id=1 cnt=538 pid=0 pos=1 obj=0 op='SORT ORDER BY (cr=5390 r=4876 w=0 time=16496559 us)'
STAT #1 id=2 cnt=538 pid=1 pos=1 obj=0 op='VIEW  (cr=5390 r=4876 w=0 time=16489237 us)'
STAT #1 id=3 cnt=538 pid=2 pos=1 obj=0 op='UNION-ALL  (cr=5390 r=4876 w=0 time=16487159 us)'
STAT #1 id=4 cnt=538 pid=3 pos=1 obj=0 op='FILTER  (cr=5389 r=4876 w=0 time=16483876 us)'
STAT #1 id=5 cnt=538 pid=4 pos=1 obj=0 op='PARTITION RANGE ITERATOR PARTITION: KEY KEY (cr=5389 r=487
6 w=0 time=16482893 us)'
STAT #1 id=6 cnt=538 pid=5 pos=1 obj=16795 op='TABLE ACCESS FULL ARCH_DATA_F PARTITION: KEY KEY (cr=5 389 r=4876 w=0 time=16477842 us)'
STAT #1 id=7 cnt=0 pid=3 pos=2 obj=0 op='FILTER (cr=1 r=0 w=0 time=73 us)' STAT #1 id=8 cnt=0 pid=7 pos=1 obj=0 op='PARTITION RANGE ITERATOR PARTITION: KEY KEY (cr=1 r=0 w=0 ti me=72 us)'
STAT #1 id=9 cnt=0 pid=8 pos=1 obj=14664 op='TABLE ACCESS BY LOCAL INDEX ROWID ARCHIVE_DATA_F PARTITI ON: KEY KEY (cr=1 r=0 w=0 time=64 us)'
STAT #1 id=10 cnt=0 pid=9 pos=1 obj=211815 op='INDEX RANGE SCAN ARCHIVE_DATA_F_INDEX PARTITION: KEY K EY (cr=1 r=0 w=0 time=59 us)'

After this the next execution of the statement with a different cur_pv_id begins.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

-----Original Message-----

From: Cary Millsap [mailto:cary.millsap_at_hotsos.com] Sent: Tuesday, July 06, 2004 8:25 PM
To: oracle-l_at_freelists.org
Subject: RE: Method R and CPU Time

I wouldn't consider 8x8KB reads to be very large either. The times when = I've encountered a big double-counting problem (for example, e=3D10, c=3D8, sum(ela)=3D8) have been for reads with p3=3D64 or p3=3D128 blocks--stuff = like that...

Can you show me the trace data for a single FETCH call (that is, the = FETCH #k line itself and all the WAIT #k lines that precede that FETCH line)?

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:

- Performance Diagnosis 101: 6/22 Pittsburgh, 7/20 Cleveland, 8/10 = Boston
- SQL Optimization 101: 5/24 San Diego, 6/14 Chicago, 6/28 Denver
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...


-----Original Message-----

From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of MacGregor, Ian A.
Sent: Tuesday, July 06, 2004 8:08 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Method R and CPU Time

I have re-read Chaper 7 especially pg 153-154, a section entitled, "CPU Consumption Double-Counting". I expected the double counting to be negligible. The text does say USUALLY negligible. Thanks also for the multi-block read information. I did not notice this discrepancy on = queries dominated by single-block read events. The multi-block reads in the example are not large, each is 8, 8k blocks or less, with very few or = less. I don't consider these to be large reads.=20

 Ian =20

-----Original Message-----

From: Cary Millsap [mailto:cary.millsap_at_hotsos.com]=20 Sent: Tuesday, July 06, 2004 1:58 PM
To: oracle-l_at_freelists.org
Subject: RE: Method R and CPU Time

Ian,

Some timed events like "SQL*Net message from client" (and "...to client" = =3D and several others) are not double-counted within any "e" value. In the = =3D book, I call these "between-call events". Other events that represent = work =3D taking place within the context of a dbcall (which I call "within-call events") /are/ included within an "e" value.

But there is potential for significant double-counting between "ela" and = =3D "c" values. I don't have a copy of the book handy (Optimizing Oracle Performance), but it's described in detail there (Chapter 7, I think). = =3D The problem will occur most prominently when your application does large multi-block reads. Basically, the issue is that the time than an I/O =3D syscall spends consuming CPU is double-counted both in "c" for the = dbcall and =3D "ela" for the read. This breaks the relationship e \approx c + \Sum ela. The larger the I/O size, the bigger the breakage.=3D20

Pictures in the book.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:

- Performance Diagnosis 101: 6/22 Pittsburgh, 7/20 Cleveland, 8/10 =3D = Boston
- SQL Optimization 101: 5/24 San Diego, 6/14 Chicago, 6/28 Denver
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...


-----Original Message-----

From: oracle-l-bounce_at_freelists.org =3D
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of MacGregor, Ian A.
Sent: Tuesday, July 06, 2004 3:48 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Method R and CPU Time

Thank you very much for responding. I decided to do away with tkprof = =3D and calculate the nubers myself. I chose another example where the =3D = statement is taking a longer time to run

Here is what I got from using the tkprof method

RUN_DATE         TRACE_ID        EVENT                               =3D
WAITS
WAIT_SECS ELAPSED_SECS CPU_SECS
-------------------------------------------------------------------------=
=3D
---

------------------------------------
26-JUN-2004 03:07 nlco_ora_2991 db file sequential read = =3D 1165 4.9 170.87 142.1 26-JUN-2004 03:07 db file scattered read = =3D 6756 147.41 170.87 142.1 26-JUN-2004 03:07 SQL*Net message from client = =3D 550 1.46 170.87 142.1 *************** =3D
----------
----------
sum = =3D 8471 153.77 And here are the waits fropm the raw trace file from the above EVENT SUM(MICROSECONDS)/1000000
------------------------------ -------------------------
SQL*Net message from client 1.469555 SQL*Net message to client .002067 db file scattered read 147.412026 db file sequential read 4.906271 latch free .000009 ------------------------- sum 153.789928 And here are the elapsed tike and CPU details from the raw trace file OPERA CPU_TIME ELAPSED_TIME
----- ---------- ------------
EXEC .03 .033659 FETCH 142.07 170.824816 PARSE 0 .013718 ---------- ------------ sum 142.1 170.872193 All cursors are at dep=3D3D0, the statement had already been parsed = before =3D this run.=3D20 SQL> select distinct misses from raw_ops_external; MISSES
----------
0 grep -i dep nlco_ora_2991.trc | wc 604 1428 44874 grep -i dep=3D3D0 nlco_ora_2991.trc | wc 604 1428 44874 grep -i dep=3D3D1 nlco_ora_2991.trc | wc 0 0 0 What I did was to "grep -I wait" and write the results to a file. I = =3D then again used the external table feature and used sum and compute to = =3D produce the report. I then did the same thing with the parse, exec, and fetch lines. The report agrees favorably with the tkprof output.=3D20 Here are the external table definitions SQL> describe raw_waits_external Name Null? Type ----------------------------------------- --------
----------------------------
TRACE_ID VARCHAR2(15) EVENT VARCHAR2(30) MICROSECONDS NUMBER(9) P1 NUMBER(15) P2 NUMBER(10) P3 NUMBER(2)=3D20 SQL> describe raw_ops_external Name Null? Type
----------------------------------------- --------
----------------------------
TRACE_ID VARCHAR2(15) OPERATION VARCHAR2(5) CPU NUMBER(10) ELAPSED NUMBER(10) PHYSICAL_R NUMBER(6) CONSISTENT_R NUMBER(6) CURRENT_R NUMBER(6) MISSES NUMBER(2) ROW_COUNT NUMBER(3) DEPTH NUMBER(2) OPT_GOAL NUMBER(2) TIM NUMBER(15) Perhaps I'm making the same mistake as tkprof as our figures agree. =3D Perhaps I have to throw out some of the lines from the trace files = despite all depths being =3D3D 0 and there being no library cache misses. Any = =3D suggestion as to where the double-counting is occuring. I'm ready to change the premise that one cannot always separate time =3D = spent on CPU and time spent waiting for file I/O via method R, because the overlap between the two may be significant not incidental to an =3D = assertion. One thing I did not mention is that the trace was done at level 12. Ian MacGregor Stanford Linear Accelerator Center ian_at_SLAC.Stanford.edu
-----Original Message-----
From: Cary Millsap [mailto:cary.millsap_at_hotsos.com]=3D20 Sent: Tuesday, July 06, 2004 9:23 AM To: oracle-l_at_freelists.org Subject: RE: Method R and CPU Time Tkprof double-counts /horribly/. It begins with how it handles the =3D3D so-called "idle events." Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 6/22 Pittsburgh, 7/20 Cleveland, 8/10 =3D3D = =3D Boston - SQL Optimization 101: 5/24 San Diego, 6/14 Chicago, 6/28 Denver - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =3D3D [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of MacGregor, Ian A. Sent: Saturday, July 03, 2004 2:31 PM To: 'oracle-l_at_freelists.org' Subject: RE: Method R and CPU Time Thanks, these figures are from tkprof on a 9.2.0.4 database. I used = =3D =3D3D grep to extract the totals for all non-recursive SQL statements and then = =3D =3D3D turned that output into an external table. I did the same thing with the = =3D3D waits. I had earlier checked the figures tkprof provides vs. the raw trace file = =3D =3D3D for the same statement run once and found they agreed. I have not = =3D summed =3D3D the waits from the raw trace file upon which tkprof was = run, but the CPU =3D and elapsed times do agree between the raw trace file and = the tkprof output. As CPU_SECS + Wait_SECS > 1.5 * Elapsed_SECS, it appears the =3D3D double-counting is not always incidental, but can be significant when = =3D there are db file =3D3D I/O waits involved. If this is true, can one = really use method R to =3D3D evaluate how a hardware upgrade will affect = performance. Remember, the figures are from tkprof which Cary states can get things wrong, and the wait times totals have not been confirmed as accurate = =3D3D =3D from the raw trace data; hence, the question is premature. Has anyone = had difficulty separating time spent waiting for file i/o vs. CPU time? Ian MacGregor Stanford Linear Accelerator Center ian_at_SLAC.Stanford.edu =3D3D20
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]=3D3D20 Sent: Saturday, July 03, 2004 3:03 AM To: oracle-l_at_freelists.org Subject: Re: Method R and CPU Time Notes in-line. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st
----- Original Message -----
From: "MacGregor, Ian A." <ian_at_slac.stanford.edu> To: <oracle-l_at_freelists.org> Sent: Friday, July 02, 2004 3:42 PM Subject: RE: Method R and CPU Time The figures represent totals from running the same statement 10 =3D3D = =3D different times with different bind variables, that is on average the elapsed time =3D =3D3D is 1.429 seconds per statement execution. Also because the report is = =3D3D =3D based on 10 runs of a statement any discrepancies in the figuring of e, = ela, =3D =3D3D or c are magnified. [jpl] Not necessarily, though you may know it to be true in your case. [jpl] In the general case, 10 runs would be more likely to flatten out anomalies [jpl] minimise descrepancies. The statements ran starting at 12:05 PM on Jun 25. Statspack from noon = =3D =3D3D to 12:15 reported 630 seconds of CPU time. Again there are four CPU's, = =3D =3D3D the machine was not overloaded. My original question had to do as to why "sum(ela)" + "c" was over 1.5 times as high as "e", and whether for a statement running on a single = =3D =3D3D CPU one needed to divide the reported CPU time by the number of = processors =3D =3D3D on the machine just as one would when looking at total CPU time = across the entire machine. If I do that, then ela + c < e, but the error is much = =3D =3D3D much less. [jpl] Without knowing what tools you are using to produce [jpl] the =3D numbers, and where they are coming from, and what [jpl] actually is happening in =3D the code, it is not possible to give [jpl] a guaranteed answer to that =3D question. But if you are just [jpl] reading v$mystat and v$session_event for the session, and [jpl] parts of the query are parallelised, you need to know that [jpl] PX slave stats are summed back to the QC, but PX slave [jpl] waits are not. So any attempt to add ela to c to get [jpl] elapsed time would be misguided. [jpl] On the other hand, you didn't mention any PX Deq wait [jpl] time, = =3D and I assumed from the reference to ela and c that [jpl] you are = processing =3D a 10046 trace file - so the simple answer [jpl] to your original question = =3D is no - you don't need to divide [jpl] the c figure by the number of processors. There are things outside of disk waits and CPU times which need to be researched. Such as why submit 10 different requests for 10 different signals. The requests themselves union a daily partioned table with indexes and a non-indexed live table holding a single calendar days = =3D3D =3D worth of data partitioned every 10 minutes. The non-indexed table is = the one reporting the scattered read waits. The table is not indexed as it = =3D3D =3D needs to collect signal data in real time and is employing direct = mode inserts =3D =3D3D via OCI. Exactly how the partition sizes were = decided, I don't know. =3D =3D3D Partition pruning is successful. No one is complaining about the above response time, but it can vary = =3D3D during the day due to machine load, and how much of the data is in =3D = cache, at =3D3D times reaching unacceptable levels. Faster hardware is being = =3D considered and =3D3D I'm trying to figure how much if any that would = help by =3D figuring how much =3D3D time is actually spent on CPU for these = queries vs. waits for physical I/O. Ian MacGregor Stanford Linear Accelerator Center ian_at_SLAC.Stanfod.edu
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------

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

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

----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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 Wed Jul 07 2004 - 12:28:28 CDT

Original text of this message

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