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.03536,69324549,2.5,326.281384 2,180.033922,69229558,2.79,324.833612 3,180.036182,69134711,2.63,326.1824 4,180.0336,69178696,2.63,325.089567 5,180.026075,68932435,3.25,324.771621 6,180.034008,68993537,2.61,326.863303 7,180.033851,69308553,3.52,325.975439 8,180.038167,69024917,2.66,327.331227 9,180.028755,68756207,2.45,328.56804 10,180.035901,69186439,2.45,327.553194 11,180.03412,68911407,3.14,322.232003 12,180.023874,68672949,2.51,325.189556 13,180.024251,68681750,2.62,323.210855 14,180.035827,68755514,2.7,325.428512 15,180.036018,68771689,2.53,326.927296 16,180.025942,68891553,2.6,325.990434 17,180.034011,69263287,2.73,327.568201 18,180.033912,68947432,2.67,327.069269 19,180.033894,68960102,2.74,324.314685 20,180.034184,69181779,2.65,326.756322 21,180.03398,69217562,2.89,326.890291 22,180.034916,69193761,2.6,325.521504 23,180.02689,69145967,3.44,327.288236 24,180.035951,69187256,3.37,327.456211 25,180.033856,69217698,2.74,327.267237 26,180.029232,69203472,2.89,327.025279 27,180.041223,69192532,3.09,324.863598 28,180.033953,68938373,2.84,324.596649 29,180.033808,69067170,2.8,323.785771 30,180.033997,68709971,2.69,327.07027 31,180.03397,68590162,2.86,326.972283 32,180.033586,68610987,2.71,327.619189 33,180.034006,69214990,3.04,325.199557 34,180.034263,69324780,2.75,326.873297 35,180.035077,69035141,2.69,328.64903 36,180.034111,68918588,2.71,326.397378 37,180.023947,68930219,3,327.240239 38,180.024114,68701616,2.67,327.605188 39,180.037083,69037895,2.92,325.716476 40,180.03719,69035645,2.72,326.608338 41,180.025074,69213149,2.55,325.154562 42,180.033842,68739231,2.74,327.242239 43,180.037978,69123303,2.73,327.096265 44,180.027838,69097706,3.49,327.563197 45,180.035187,69250906,2.66,327.278234 46,180.035996,69404145,2.85,327.728169 47,180.027114,69213953,2.71,327.326228 48,180.037077,69368652,3,327.640185 49,180.033854,69016612,2.55,326.881299 50,180.033831,69263491,3.11,325.340533 51,180.033863,69173223,2.55,326.896293 52,180.034005,69187024,2.68,325.749478 53,180.024973,69190936,2.7,325.805457 54,180.023859,68904744,2.62,327.853149 55,180.034158,68947689,2.61,327.400217 56,180.034012,69146034,3.13,327.273236 57,180.033966,69270804,2.89,327.950139 58,180.033798,69073771,2.88,323.400827 59,180.034136,69211083,2.89,327.893149 60,180.033763,69087935,2.93,328.441058 61,180.034225,69167976,2.75,327.88215 62,180.034001,68730732,2.89,327.151255 63,180.028902,68925130,3.21,324.770621 64,180.037017,69120142,2.76,326.513353 65,180.025006,69128031,2.79,327.290239 66,180.023992,69223008,2.96,326.577342 67,180.033816,69146951,2.57,328.237091 68,180.037106,69239835,2.69,326.271394 69,180.034085,69100149,2.86,325.314541 70,180.035951,69226158,2.73,327.043272 71,180.023978,69155958,2.83,327.082264 72,180.024012,69095720,2.83,325.244547 73,180.034036,68932448,2.8,325.173554 74,180.040978,69193270,2.93,326.623338 75,180.028927,69405241,2.63,326.502357 76,180.02816,69155045,2.99,326.071421 77,180.026787,69297115,2.59,327.003282 78,180.035733,69295240,3.01,328.032122 79,180.033999,69142349,3.07,326.436363 80,180.033996,69210028,2.76,328.184104 81,180.025075,69115571,3.29,326.231397 82,180.03589,69166349,2.73,324.728625 83,180.03382,69063508,2.96,325.584496 84,180.034663,68997307,2.64,323.311846 85,180.034074,68861946,2.82,325.380524 86,180.034106,68945191,2.69,326.562346 87,180.033778,69248445,2.76,324.984588 88,180.024145,69033459,2.87,326.441367 89,180.023828,68642249,3,326.965282 90,180.033963,69214226,2.67,325.061579 90 rows selected. SQL> SQL> 2 3 4 5 6 7 385.06074 .004706578 .000036062 .00474264 384.536188 .004692123 .000040301 .004732424 384.004539 .00471807 .000038042 .004756112 384.254361 .004699273 .000038017 .00473729 382.902505 .004711449 .000047148 .004758596 383.225024 .004737593 .00003783 .004775423 384.975118 .00470325 .000050787 .004754037 383.390467 .004742218 .000038537 .004780755 381.917916 .00477874 .000035633 .004814373 384.292458 .004734355 .000035412 .004769767 382.768594 .004676033 .000045566 .004721599 381.465788 .004735337 .00003655 .004771887 381.513877 .00470592 .000038147 .004744067 381.899065 .004733126 .00003927 .004772396 381.988503 .004753806 .000036788 .004790595 382.675698 .004731936 .00003774 .004769677 384.723345 .004729319 .000039415 .004768734 382.969138 .004743748 .000038725 .004782474 383.039551 .004702932 .000039733 .004742665 384.270239 .004723156 .000038305 .004761461 384.469432 .00472265 .000041752 .004764402 384.335231 .004704492 .000037576 .004742068 384.086883 .004733295 .00004975 .004783044 384.29689 .004732898 .000048708 .004781606 384.470452 .004728086 .000039585 .004767671 384.401307 .004725562 .000041761 .004767323 384.314941 .004695067 .000044658 .004739725 382.918732 .004708505 .000041196 .004749701 383.634445 .004687984 .00004054 .004728524 381.649978 .004760157 .00003915 .004799307 380.984555 .004767043 .000041697 .00480874 381.101041 .004775025 .000039498 .004814523 384.45509 .004698398 .000043921 .004742319 385.06437 .0047151 .000039668 .004754769 383.453837 .004760605 .000038966 .004799571 382.8085 .004735985 .000039322 .004775306 382.894721 .004747413 .000043522 .004790936 381.624519 .004768522 .000038864 .004807386 383.464861 .004717938 .000042296 .004760233 383.452136 .00473101 .0000394 .00477041 384.463939 .004697873 .000036843 .004734715 381.812832 .004760633 .000039861 .004800494 383.937343 .004732069 .000039495 .004771564 383.816785 .00474058 .000050508 .004791088 384.652062 .004725978 .000038411 .004764389 385.501492 .004722026 .000041064 .00476309 384.464048 .004729194 .000039154 .004768348 385.302034 .004723174 .000043247 .004766421 383.353522 .00473627 .000036948 .004773217 384.724863 .004697143 .000044901 .004742044 384.2234 .004725764 .000036864 .004762627 384.299755 .004708245 .000038736 .004746981 384.340766 .004708788 .000039022 .004747811 382.753399 .004758064 .000038024 .004796087 382.970042 .004748531 .000037855 .004786385 384.072061 .004733073 .000045267 .00477834 384.765195 .00473432 .00004172 .00477604 383.671132 .004681963 .000041695 .004723657 384.433111 .004737582 .000041756 .004779338 383.74988 .004753957 .00004241 .004796367 384.193483 .004740375 .000039758 .004780133 381.765287 .004759898 .000042048 .004801946 382.855915 .004711933 .000046572 .004758506 383.921835 .004723852 .00003993 .004763783 383.991272 .004734552 .00004036 .004774912 384.521014 .004717757 .00004276 .004760518 384.077572 .00474695 .000037167 .004784117 384.58647 .004712192 .00003885 .004751042 383.817037 .00470787 .000041389 .00474926 384.512969 .004724273 .000039436 .004763709 384.148594 .004729632 .000040922 .004770554 383.81391 .004707159 .000040958 .004748117 382.885645 .004717278 .000040619 .004757898 384.319563 .00472045 .000042345 .004762795 385.522717 .00470429 .000037893 .004742183 384.134599 .004715078 .000043236 .004758314 384.926689 .004718859 .000037375 .004756234 384.897147 .004733833 .000043437 .004777271 384.05162 .004721222 .000044401 .004765623 384.42755 .004741858 .000039879 .004781736 383.921912 .004720085 .000047601 .004767687 384.180893 .004694893 .00003947 .004734363 383.614079 .004714277 .000042859 .004757136 383.24457 .004685862 .000038262 .004724124 382.493961 .004725114 .000040952 .004766065 382.956277 .00473655 .000039016 .004775567 384.641403 .004693024 .000039856 .00473288 383.467779 .004728741 .000041574 .004770315 381.295353 .004763324 .000043705 .004807029 384.450938 .004696456 .000038576 .004735032 90 rows selected. SQL> SQL> .004706578 .004692123 .00471807 .004699273 .004711449 .004737593 .00470325 .004742218 .00477874 .004734355 .004676033 .004735337 .00470592 .004733126 .004753806 .004731936 .004729319 .004743748 .004702932 .004723156 .00472265 .004704492 .004733295 .004732898 .004728086 .004725562 .004695067 .004708505 .004687984 .004760157 .004767043 .004775025 .004698398 .0047151 .004760605 .004735985 .004747413 .004768522 .004717938 .00473101 .004697873 .004760633 .004732069 .00474058 .004725978 .004722026 .004729194 .004723174 .00473627 .004697143 .004725764 .004708245 .004708788 .004758064 .004748531 .004733073 .00473432 .004681963 .004737582 .004753957 .004740375 .004759898 .004711933 .004723852 .004734552 .004717757 .00474695 .004712192 .00470787 .004724273 .004729632 .004707159 .004717278 .00472045 .00470429 .004715078 .004718859 .004733833 .004721222 .004741858 .004720085 .004694893 .004714277 .004685862 .004725114 .00473655 .004693024 .004728741 .004763324 .004696456 90 rows selected. SQL> SQL> SQL> SQL>