SQL> set tab off set pagesize 0 col sample_no noprint select sample_no, sample_no||','||elapsed_s||','||lio_tot||','||wait_time_s||','||sys_cpu_s from results order by 1; select sample_no, lio_tot/(1000*elapsed_s) l_lio_ms, sys_cpu_s*1000/lio_tot st_ms_lio, wait_time_s*1000/lio_tot qt_ms_lio, (sys_cpu_s+wait_time_s)*1000/lio_tot rt_ms_lio from results order by 1; select sys_cpu_s*1000/lio_tot st_ms_lio from results; SQL> SQL> SQL> SQL> 1,180.017408,81134550,3.7,356.020877 2,180.014226,81231224,4.37,358.330518 3,180.020947,81216485,4.16,356.727767 4,180.013077,81055210,3.85,357.454657 5,180.016722,80850616,4.2,358.114553 6,180.01805,81360753,4.1,356.732768 7,180.017356,81114263,3.94,358.136558 8,180.012102,81229315,3.51,359.013417 9,180.012728,81165506,3.45,356.491805 10,180.021006,81435901,4.13,358.319521 11,180.015028,81430766,3.6,356.926733 12,180.01272,81417758,3.81,357.979581 13,180.020168,81459200,4.02,358.08956 14,180.013849,81412080,3.38,356.17385 15,180.014553,81336471,4.49,355.695927 16,180.011765,81406088,3.88,358.63448 17,180.021441,81160666,3.53,358.638478 18,180.019512,81501570,4.25,357.365666 19,180.019038,81437780,4.36,358.4835 20,180.019577,81251078,4.21,358.082563 21,180.019669,81549051,4.21,357.983573 22,180.021028,81491095,3.72,357.461655 23,180.015896,81271777,3.79,358.409513 24,180.020962,81039109,3.98,358.291532 25,180.016238,81272111,3.69,357.905586 26,180.01602,81270858,4,358.454502 27,180.013435,81350587,4.16,357.826601 28,180.021394,81316955,4.4,358.228534 29,180.012551,81220988,5.19,356.476807 30,180.015457,81338826,4.48,355.169003 31,180.013521,81386980,4.27,358.566485 32,180.012814,81389892,4.18,358.794457 33,180.015676,81459395,4.09,358.438504 34,180.016947,81575713,4.04,358.391514 35,180.020034,81473269,3.31,357.843601 36,180.014383,81252705,3.83,358.386509 37,180.019604,81183685,5.28,358.059564 38,180.020199,80984358,4.02,358.299532 39,180.019346,81197410,3.98,355.420972 40,180.020211,81000481,3.96,357.643631 41,180.02056,81629042,4.18,357.67962 42,180.015074,81408384,4.28,357.873597 43,180.02189,81349386,5.01,358.024569 44,180.019369,81171793,3.97,358.41551 45,180.019366,81361034,3.66,357.093714 46,180.019077,81516682,4.4,355.338974 47,180.01397,81271926,4.15,357.546643 48,180.02055,81582754,4.22,357.660623 49,180.015502,81259520,4.65,359.257384 50,180.019172,81444507,3.86,357.288683 51,180.01502,81293992,3.81,357.789609 52,180.014456,81571248,4.53,357.674624 53,180.015801,81514571,3.27,356.402819 54,180.013847,81331185,3.76,357.321678 55,180.013235,80875681,3.09,357.506651 56,180.015863,81379899,5.37,358.21354 57,180.018965,81246904,5.08,357.333672 58,180.019224,81398179,3.8,358.275531 59,180.019954,81281053,4.02,354.540101 60,180.012776,81355102,4.54,358.638484 61,180.014185,81161845,3.59,358.198544 62,180.013937,81291030,4.65,358.187548 63,180.01362,81286551,4.62,357.738612 64,180.017316,81186698,4.52,358.182547 65,180.017262,81309450,5.4,357.849601 66,180.015656,81019488,7.06,359.562332 67,180.01282,81437001,31.39,402.925739 68,180.021236,80614386,13.41,359.777301 69,180.020765,80404963,4.41,359.225386 70,180.020416,80553578,5.06,359.553343 71,180.020508,80656560,4.31,358.942429 72,180.020982,80743585,5.19,359.091405 73,180.022093,80675416,4.11,359.869291 74,180.022599,80772832,4.44,359.167396 75,180.02257,80522754,5.31,358.833444 76,180.015053,80756541,6.76,359.74331 77,180.014857,80585617,4.29,359.026423 78,180.020014,80658026,4.5,359.402357 79,180.014319,80549079,4.64,359.344367 80,180.016494,80544655,6.03,359.389366 81,180.020973,80559766,3.12,358.954429 82,180.022113,80376955,4.49,357.351677 83,180.013407,80175439,5.41,358.958429 84,180.013133,80529896,4.79,360.488196 85,180.020694,80216490,4.08,358.130554 86,180.020319,81101309,4.82,359.016412 87,180.019585,80352984,4.35,358.024574 88,180.019316,80946907,4.22,359.634321 89,180.020871,80687136,4.09,358.03357 90,180.02223,80806051,4.87,359.168399 90 rows selected. SQL> SQL> 2 3 4 5 6 7 450.703912 .00438803 .000045603 .004433634 451.248914 .004411241 .000053797 .004465038 451.150193 .004392307 .000051221 .004443529 450.27401 .004410015 .000047498 .004457513 449.128365 .004429336 .000051948 .004481284 451.958862 .00438458 .000050393 .004434973 450.591347 .004415211 .000048573 .004463784 451.243634 .004419752 .000043211 .004462963 450.887595 .004392159 .000042506 .004434665 452.368881 .004400019 .000050715 .004450734 452.355378 .004383193 .000044209 .004427402 452.288916 .004396824 .000046796 .00444362 452.500411 .004395938 .00004935 .004445287 452.254537 .004374951 .000041517 .004416468 451.832753 .004373142 .000055203 .004428345 452.226486 .0044055 .000047662 .004453162 450.838886 .004418871 .000043494 .004462365 452.737423 .00438477 .000052146 .004436917 452.384264 .004401931 .000053538 .004455469 451.345789 .004407112 .000051815 .004458926 453.000783 .004389794 .000051625 .00444142 452.675423 .004386512 .000045649 .004432161 451.470002 .004410012 .000046634 .004456646 450.164848 .004421218 .000049112 .00447033 451.471 .004403793 .000045403 .004449196 451.464586 .004410615 .000049218 .004459834 451.913975 .004398574 .000051137 .004449711 451.707173 .004405336 .000054109 .004459446 451.19625 .004388974 .0000639 .004452874 451.843566 .004366537 .000055078 .004421615 452.115927 .004405698 .000052465 .004458164 452.13388 .004408342 .000051358 .004459699 452.512786 .004400211 .000050209 .00445042 453.155741 .00439336 .000049525 .004442885 452.5789 .00439216 .000040627 .004432786 451.36785 .004410764 .000047137 .004457901 450.971356 .004410487 .000065038 .004475524 449.862618 .004424305 .000049639 .004473945 451.048245 .004377245 .000049016 .004426262 449.95215 .004415327 .000048889 .004464216 453.442885 .004381769 .000051207 .004432976 452.230928 .004396029 .000052574 .004448603 451.886079 .004401073 .000061586 .004462659 450.905886 .004415518 .000048909 .004464427 451.957119 .004389002 .000044985 .004433986 452.822464 .004359095 .000053977 .004413072 451.47566 .004399387 .000051063 .00445045 453.185784 .004384022 .000051727 .004435749 451.402902 .004421111 .000057224 .004478335 452.421295 .004386897 .000047394 .004434291 451.595606 .004401181 .000046867 .004448048 453.137208 .004384812 .000055534 .004440347 452.818978 .004372259 .000040116 .004412375 451.80516 .004393415 .000046231 .004439646 449.276305 .004420447 .000038207 .004458654 452.07071 .004401745 .000065987 .004467732 451.324137 .00439812 .000062525 .004460646 452.163814 .004401518 .000046684 .004448202 451.511353 .004361903 .000049458 .004411361 451.940711 .00440831 .000055805 .004464114 450.863608 .004413386 .000044233 .004457619 451.581868 .004406237 .000057202 .004463439 451.557782 .004400957 .000056836 .004457793 450.993826 .004411838 .000055674 .004467512 451.675851 .004401083 .000066413 .004467495 450.069121 .004437973 .00008714 .004525113 452.395563 .004947699 .000385451 .00533315 447.804869 .004462942 .000166347 .004629289 446.642714 .004467702 .000054847 .004522549 447.469125 .00446353 .000062815 .004526346 448.040953 .004450257 .000053436 .004503694 448.523189 .004447306 .000064278 .004511583 448.141751 .004460706 .000050945 .004511651 448.681624 .004446636 .000054969 .004501605 447.292548 .004456299 .000065944 .004522243 448.609934 .004454665 .000083708 .004538373 447.660923 .004455217 .000053235 .004508452 448.050326 .004455878 .000055791 .00451167 447.459288 .004461185 .000057605 .00451879 447.429306 .004461989 .000074865 .004536854 447.502114 .004455753 .000038729 .004494482 446.483788 .004445947 .000055862 .004501809 445.385932 .004477162 .000067477 .004544639 447.355672 .004476452 .000059481 .004535933 445.595938 .00446455 .000050862 .004515413 450.511972 .004426765 .000059432 .004486197 446.356901 .004455648 .000054136 .004509784 449.656786 .004442842 .000052133 .004494975 448.209897 .004437307 .00005069 .004487996 448.86707 .004444821 .000060268 .004505088 90 rows selected. SQL> SQL> .00438803 .004411241 .004392307 .004410015 .004429336 .00438458 .004415211 .004419752 .004392159 .004400019 .004383193 .004396824 .004395938 .004374951 .004373142 .0044055 .004418871 .00438477 .004401931 .004407112 .004389794 .004386512 .004410012 .004421218 .004403793 .004410615 .004398574 .004405336 .004388974 .004366537 .004405698 .004408342 .004400211 .00439336 .00439216 .004410764 .004410487 .004424305 .004377245 .004415327 .004381769 .004396029 .004401073 .004415518 .004389002 .004359095 .004399387 .004384022 .004421111 .004386897 .004401181 .004384812 .004372259 .004393415 .004420447 .004401745 .00439812 .004401518 .004361903 .00440831 .004413386 .004406237 .004400957 .004411838 .004401083 .004437973 .004947699 .004462942 .004467702 .00446353 .004450257 .004447306 .004460706 .004446636 .004456299 .004454665 .004455217 .004455878 .004461185 .004461989 .004455753 .004445947 .004477162 .004476452 .00446455 .004426765 .004455648 .004442842 .004437307 .004444821 90 rows selected.