Created on May 26, 2010 buy Craig Shallahamer, craig@orapub.com Use completely at your own risk. ------------------------------------------------------------------ THE GRANTS ------------------------------------------------------------------ connect / as sysdba grant select on v_$sess_time_model to system; grant select on v_$sys_time_model to system; grant select on v_$mystat to system; grant select on v_$sysstat to system; grant select on v_$system_event to system; connect system/manager ------------------------------------------------------------------ THE DDL ------------------------------------------------------------------ drop table logsync_results; create table logsync_results ( test_id varchar2(10), sample number, tot_rows number, batch_size number, my_cpu_time_s number, sys_cpu_time_s number, sys_wait_time_s number, elapsed_time_s number, tot_blk_changes number ); drop table logsync_work; create table logsync_work ( c1 number, c2 number, c3 number, t1 varchar2(50) ); ------------------------------------------------------------------ THE PROGRAMATIC STRUCTRES ------------------------------------------------------------------ create or replace function get_interval_s(i_intrvl interval day to second) return number is begin return extract(day from i_intrvl) * 86400 + extract(hour from i_intrvl) * 3600 + extract(minute from i_intrvl) * 60 + extract(second from i_intrvl); exception when others then begin return null; end; end; / -- A LITTLE TEST..just in case... set serveroutput on declare t0 timestamp; t1 timestamp; delta number; begin select current_timestamp into t0 from dual; dbms_lock.sleep(3); select current_timestamp into t1 from dual; select get_interval_s(t1-t0) into delta from dual; dbms_output.put_line('delta='||delta); end; / create or replace function get_my_cpu_s return number is the_results number; begin select value into the_results from v$sess_time_model where stat_name = 'DB CPU' and sid = (select Sid from v$mystat where rownum = 1); return the_results/1000000 ; end; / create or replace procedure logsync1 (tot_rows in number, batch_size in number) is i number; cycles number; b number; begin cycles := trunc(tot_rows / batch_size) ; for i in 1..cycles loop for b in 1..batch_size loop insert into logsync_work values (i,b,0,'insert bla bla'); end loop; commit; end loop; commit; end; / ----------------------------------- This is the main experimental procedure ----------------------------------- create or replace procedure logsync2 (test_no in number, max_samples in number, tot_rows in number, max_batch_size in number) is time_t0 timestamp; time_t1 timestamp; time_delta_s number; my_cpu_t0 number; my_cpu_t1 number; my_cpu_delta_s number; sys_cpu_t0 number; sys_cpu_t1 number; sys_cpu_delta_s number; wait_time_t0 number; wait_time_t1 number; sys_wait_time_s number; tot_blk_changes number; blk_changes_t1 number; blk_changes_t0 number; sample number; batch_size number; loop_count number; max_loop_count number; begin logsync1(tot_rows,1); max_loop_count := round(log(2,max_batch_size),0); for loop_count in 0..max_loop_count loop batch_size := power(2,loop_count) ; for sample in 1..max_samples loop delete logsync_work; commit; select current_timestamp into time_t0 from dual; --select value into blk_changes_t0 from v$sysstat where name='db block changes'; select sum(time_waited)/100 into wait_time_t0 from v$system_event where wait_class != 'Idle'; select sum(value)/1000000 into sys_cpu_t0 from v$sys_time_model where stat_name in ('DB CPU','background cpu time'); select get_my_cpu_s into my_cpu_t0 from dual; logsync1(tot_rows,batch_size); select get_my_cpu_s into my_cpu_t1 from dual; select sum(value)/1000000 into sys_cpu_t1 from v$sys_time_model where stat_name in ('DB CPU','background cpu time'); select current_timestamp into time_t1 from dual; --select value into blk_changes_t1 from v$sysstat where name='db block changes'; select sum(time_waited)/100 into wait_time_t1 from v$system_event where wait_class != 'Idle'; select get_interval_s(time_t1-time_t0) into time_delta_s from dual; my_cpu_delta_s := my_cpu_t1 - my_cpu_t0 ; sys_cpu_delta_s := sys_cpu_t1 - sys_cpu_t0 ; sys_wait_time_s := wait_time_t1 - wait_time_t0 ; tot_blk_changes := blk_changes_t1 - blk_changes_t0 ; insert into logsync_results values (test_no,sample,tot_rows,batch_size,my_cpu_delta_s,sys_cpu_delta_s, sys_wait_time_s,time_delta_s,tot_blk_changes); commit; end loop; end loop; end; / ------------------------------------------------------------------ HOW TO RUN THE EXPERIMENT ------------------------------------------------------------------ set tab off set linesize 130 truncate table logsync_results; -- quick test exec logsync2(1,3,40000,40000); -- full on experiment (overnight) exec logsync2(1,35,900000,40000); -- observe the raw results select * from logsync_results; -- After an all night experiement, I want to ensure I don't erase my data! drop table logsync_save&ver; create table logsync_save&ver as select * from logsync_results; ------------------------------------------------------------------ THE REPORTS ------------------------------------------------------------------ -- Use this to understand the experiment result "spread." select batch_size, avg(sys_cpu_time_s),stddev(sys_cpu_time_s), avg(sys_wait_time_s),stddev(sys_wait_time_s), avg(ELAPSED_TIME_S),stddev(ELAPSED_TIME_S) from logsync_results group by batch_size order by batch_size / -- Column definitions for all the below scripts set tab off set linesize 300 col batch_size format 99999 heading 'Batch|Size' col tot_rows format 999990 heading 'Total|Rows' col sample_size format 999 heading 'Samples' col avg_work_per_ms format 9,990.0000 heading 'Arrival Rate|(&wl/ms)' col avg_sys_cpu_ms_per_work format 90.0000 heading 'Service Time|(ms/&wl)' col avg_sys_queue_ms_per_work format 90.0000 heading 'Queue Time|(ms/&wl)' col avg_rt_ms_per_work format 90.0000 heading 'Respone Time|(ms/&wl)' col avg_requirements format 9,9990.000 heading 'Requirements' col avg_elapsed_time_s format 9,990.0000 heading 'Elapsed|Time (sec)' col pct_change format 990.00 heading '%|Change' -- Classic report to see elapse time change as the batch size changes. select batch_size,avg(elapsed_time_s) avg_elapsed_time_s from logsync_results group by batch_size order by batch_size / -- Another way to view the situation, which I did not present in my blog entry def wl=batch select batch_size, tot_rows, count(sample) sample_size, avg((tot_rows/batch_size)/(1000*elapsed_time_s)) avg_commits_per_ms, avg((1000*sys_cpu_time_s)/(tot_rows/batch_size)) avg_sys_cpu_ms_per_commit, avg((1000*sys_wait_time_s)/(tot_rows/batch_size)) avg_sys_queue_ms_per_commit, avg(((1000*sys_cpu_time_s)/(tot_rows/batch_size))+((1000*sys_wait_time_s)/(tot_rows/batch_size))) avg_rt_ms_per_commit from logsync_results group by batch_size,tot_rows order by batch_size,tot_rows / -- WL: row inserts -- the def is used to make the column headings more flexible def wl=inserts ---- -- Need this to calculate pct change col val1 new_val max_work_per_ms col val2 new_val max_sys_cpu_ms_per_work col val3 new_val max_sys_queue_ms_per_work col val4 new_val max_rt_ms_per_work col val5 new_val max_elapsed_time_s select avg((tot_rows)/(1000*elapsed_time_s)) val1, avg((1000*sys_cpu_time_s)/(tot_rows)) val2, avg((1000*sys_wait_time_s)/(tot_rows)) val3, avg(((1000*sys_cpu_time_s)/(tot_rows))+((1000*sys_wait_time_s)/(tot_rows))) val4, avg(elapsed_time_s) val5 from logsync_results where batch_size = 1 / ---- ---- Here are the core reports I used in the blog and used to create the graphs ---- select batch_size, tot_rows, count(sample) sample_size, avg(elapsed_time_s) avg_elapsed_time_s, 100*((avg(elapsed_time_s)/&max_elapsed_time_s)-1) pct_change from logsync_results group by batch_size,tot_rows order by batch_size,tot_rows / select batch_size, tot_rows, count(sample) sample_size, avg(elapsed_time_s) avg_elapsed_time_s, avg((tot_rows)/(1000*elapsed_time_s)) avg_work_per_ms, avg((1000*sys_cpu_time_s)/(tot_rows)) avg_sys_cpu_ms_per_work, avg((1000*sys_wait_time_s)/(tot_rows)) avg_sys_queue_ms_per_work, avg(((1000*sys_cpu_time_s)/(tot_rows))+((1000*sys_wait_time_s)/(tot_rows))) avg_rt_ms_per_work from logsync_results group by batch_size,tot_rows order by batch_size,tot_rows / select batch_size, avg((tot_rows)/(1000*elapsed_time_s)) avg_work_per_ms, 100*((avg(tot_rows/(1000*elapsed_time_s))/&max_work_per_ms)-1) pct_change, avg((1000*sys_cpu_time_s)/(tot_rows)) avg_sys_cpu_ms_per_work, 100*((avg((1000*sys_cpu_time_s)/(tot_rows))/&max_sys_cpu_ms_per_work)-1) pct_change, avg((sys_wait_time_s*1000)/(tot_rows)) avg_sys_queue_ms_per_work, 100*((avg((1000*sys_wait_time_s)/(tot_rows))/&max_sys_queue_ms_per_work)-1) pct_change, avg(((1000*sys_cpu_time_s)/(tot_rows))+((1000*sys_wait_time_s)/(tot_rows))) avg_rt_ms_per_work, 100*((avg(((1000*sys_cpu_time_s)/(tot_rows))+((1000*sys_wait_time_s)/(tot_rows)))/&max_rt_ms_per_work)-1) pct_change from logsync_results group by batch_size,tot_rows order by batch_size,tot_rows / select * from logsync_results; ------------------------------------------------------------------ THE REPORT OUTPUT ------------------------------------------------------------------ SQL> l 1 select batch_size, 2 avg(sys_cpu_time_s),stddev(sys_cpu_time_s), 3 avg(sys_wait_time_s),stddev(sys_wait_time_s), 4 avg(ELAPSED_TIME_S),stddev(ELAPSED_TIME_S) 5 from logsync_results 6 group by batch_size 7* order by batch_size SQL> / Batch Size AVG(SYS_CPU_TIME_S) STDDEV(SYS_CPU_TIME_S) AVG(SYS_WAIT_TIME_S) STDDEV(SYS_WAIT_TIME_S) AVG(ELAPSED_TIME_S) STDDEV(ELAPSED_TIME_S) ------ ------------------- ---------------------- -------------------- ----------------------- ------------------- ---------------------- 1 82.3038851 1.02083485 122.004571 3.54091991 82.9945088 .536979325 2 65.014229 .752093689 96.4294286 3.88853439 64.9539659 .5802635 4 55.1856088 .891603385 82.218 2.98372625 55.4024901 .668788193 8 50.7450271 .665603768 76.9668571 3.0499101 50.6215963 .621576421 16 48.3672744 .73951315 70.6225714 2.45259927 47.9620497 .441651425 32 47.1133787 .822830379 23.4102857 .879704114 45.0470078 .126419169 64 46.3847471 .462542957 15.9562857 4.0723841 44.4585219 .141650148 128 46.0046621 .621375071 12.5771429 8.46613759 44.419067 .610949842 256 45.6189202 .558187245 10.316 3.84061974 43.9992096 .389556499 512 44.8860605 .979699458 8.82142857 .622349168 43.7341907 .081628731 1024 45.0458648 .950996306 15.4571429 5.10370775 43.6555319 .487301093 2048 44.9825025 .850936771 13.7197143 3.208876 43.5763049 .11364514 4096 44.8344683 1.05511301 13.0402857 4.33223179 43.7082742 .439498123 8192 44.5841352 .986998668 10.7131429 .565028742 43.5301693 .124066087 16384 46.5579778 6.77769125 15.8862857 15.0235476 43.2844177 .498706187 32768 44.4192461 .970642058 10.1034286 1.74083304 43.1086377 .146793318 16 rows selected. SQL> l 1 select batch_size, 2 tot_rows, 3 count(sample) sample_size, 4 avg(elapsed_time_s) avg_elapsed_time_s, 5 100*((avg(elapsed_time_s)/&max_elapsed_time_s)-1) pct_change 6 from logsync_results 7 group by batch_size,tot_rows 8* order by batch_size,tot_rows SQL> / old 5: 100*((avg(elapsed_time_s)/&max_elapsed_time_s)-1) pct_change new 5: 100*((avg(elapsed_time_s)/82.9945088)-1) pct_change Batch Total Elapsed % Size Rows Samples Time (sec) Change ------ ------- ------- ----------- ------- 1 900000 35 82.9945 -0.00 2 900000 35 64.9540 -21.74 4 900000 35 55.4025 -33.25 8 900000 35 50.6216 -39.01 16 900000 35 47.9620 -42.21 32 900000 35 45.0470 -45.72 64 900000 35 44.4585 -46.43 128 900000 35 44.4191 -46.48 256 900000 35 43.9992 -46.99 512 900000 35 43.7342 -47.30 1024 900000 35 43.6555 -47.40 2048 900000 35 43.5763 -47.49 4096 900000 35 43.7083 -47.34 8192 900000 35 43.5302 -47.55 16384 900000 35 43.2844 -47.85 32768 900000 35 43.1086 -48.06 16 rows selected. SQL> l 1 select batch_size, 2 tot_rows, 3 count(sample) sample_size, 4 avg(elapsed_time_s) avg_elapsed_time_s, 5 avg((tot_rows)/(1000*elapsed_time_s)) avg_work_per_ms, 6 avg((1000*sys_cpu_time_s)/(tot_rows)) avg_sys_cpu_ms_per_work, 7 avg((1000*sys_wait_time_s)/(tot_rows)) avg_sys_queue_ms_per_work, 8 avg(((1000*sys_cpu_time_s)/(tot_rows))+((1000*sys_wait_time_s)/(tot_rows))) avg_rt_ms_per_work 9 from logsync_results 10 group by batch_size,tot_rows 11* order by batch_size,tot_rows SQL> / Batch Total Elapsed Arrival Rate Service Time Queue Time Respone Time Size Rows Samples Time (sec) (inserts/ms) (ms/inserts) (ms/inserts) (ms/inserts) ------ ------- ------- ----------- ------------ ------------ ------------ ------------ 1 900000 35 82.9945 10.8445 0.0914 0.1356 0.2270 2 900000 35 64.9540 13.8570 0.0722 0.1071 0.1794 4 900000 35 55.4025 16.2470 0.0613 0.0914 0.1527 8 900000 35 50.6216 17.7815 0.0564 0.0855 0.1419 16 900000 35 47.9620 18.7664 0.0537 0.0785 0.1322 32 900000 35 45.0470 19.9793 0.0523 0.0260 0.0784 64 900000 35 44.4585 20.2438 0.0515 0.0177 0.0693 128 900000 35 44.4191 20.2650 0.0511 0.0140 0.0651 256 900000 35 43.9992 20.4564 0.0507 0.0115 0.0621 512 900000 35 43.7342 20.5789 0.0499 0.0098 0.0597 1024 900000 35 43.6555 20.6183 0.0501 0.0172 0.0672 2048 900000 35 43.5763 20.6536 0.0500 0.0152 0.0652 4096 900000 35 43.7083 20.5930 0.0498 0.0145 0.0643 8192 900000 35 43.5302 20.6755 0.0495 0.0119 0.0614 16384 900000 35 43.2844 20.7953 0.0517 0.0177 0.0694 32768 900000 35 43.1086 20.8777 0.0494 0.0112 0.0606 16 rows selected. SQL> l 1 select batch_size, 2 avg((tot_rows)/(1000*elapsed_time_s)) avg_work_per_ms, 3 100*((avg(tot_rows/(1000*elapsed_time_s))/&max_work_per_ms)-1) pct_change, 4 avg((1000*sys_cpu_time_s)/(tot_rows)) avg_sys_cpu_ms_per_work, 5 100*((avg((1000*sys_cpu_time_s)/(tot_rows))/&max_sys_cpu_ms_per_work)-1) pct_change, 6 avg((sys_wait_time_s*1000)/(tot_rows)) avg_sys_queue_ms_per_work, 7 100*((avg((1000*sys_wait_time_s)/(tot_rows))/&max_sys_queue_ms_per_work)-1) pct_change, 8 avg(((1000*sys_cpu_time_s)/(tot_rows))+((1000*sys_wait_time_s)/(tot_rows))) avg_rt_ms_per_work, 9 100*((avg(((1000*sys_cpu_time_s)/(tot_rows))+((1000*sys_wait_time_s)/(tot_rows)))/&max_rt_ms_per_work)-1) pct_change 10 from logsync_results 11 group by batch_size,tot_rows 12* order by batch_size,tot_rows SQL> / old 3: 100*((avg(tot_rows/(1000*elapsed_time_s))/&max_work_per_ms)-1) pct_change, new 3: 100*((avg(tot_rows/(1000*elapsed_time_s))/10.8445324)-1) pct_change, old 5: 100*((avg((1000*sys_cpu_time_s)/(tot_rows))/&max_sys_cpu_ms_per_work)-1) pct_change, new 5: 100*((avg((1000*sys_cpu_time_s)/(tot_rows))/.091448761)-1) pct_change, old 7: 100*((avg((1000*sys_wait_time_s)/(tot_rows))/&max_sys_queue_ms_per_work)-1) pct_change, new 7: 100*((avg((1000*sys_wait_time_s)/(tot_rows))/.135560635)-1) pct_change, old 9: 100*((avg(((1000*sys_cpu_time_s)/(tot_rows))+((1000*sys_wait_time_s)/(tot_rows)))/&max_rt_ms_per_work)-1) pct_change new 9: 100*((avg(((1000*sys_cpu_time_s)/(tot_rows))+((1000*sys_wait_time_s)/(tot_rows)))/.227009396)-1) pct_change Batch Arrival Rate % Service Time % Queue Time % Respone Time % Size (inserts/ms) Change (ms/inserts) Change (ms/inserts) Change (ms/inserts) Change ------ ------------ ------- ------------ ------- ------------ ------- ------------ ------- 1 10.8445 0.00 0.0914 0.00 0.1356 -0.00 0.2270 0.00 2 13.8570 27.78 0.0722 -21.01 0.1071 -20.96 0.1794 -20.98 4 16.2470 49.82 0.0613 -32.95 0.0914 -32.61 0.1527 -32.75 8 17.7815 63.97 0.0564 -38.34 0.0855 -36.91 0.1419 -37.49 16 18.7664 73.05 0.0537 -41.23 0.0785 -42.11 0.1322 -41.76 32 19.9793 84.23 0.0523 -42.76 0.0260 -80.81 0.0784 -65.48 64 20.2438 86.67 0.0515 -43.64 0.0177 -86.92 0.0693 -69.49 128 20.2650 86.87 0.0511 -44.10 0.0140 -89.69 0.0651 -71.33 256 20.4564 88.63 0.0507 -44.57 0.0115 -91.54 0.0621 -72.62 512 20.5789 89.76 0.0499 -45.46 0.0098 -92.77 0.0597 -73.71 1024 20.6183 90.13 0.0501 -45.27 0.0172 -87.33 0.0672 -70.39 2048 20.6536 90.45 0.0500 -45.35 0.0152 -88.75 0.0652 -71.27 4096 20.5930 89.89 0.0498 -45.53 0.0145 -89.31 0.0643 -71.67 8192 20.6755 90.65 0.0495 -45.83 0.0119 -91.22 0.0614 -72.93 16384 20.7953 91.76 0.0517 -43.43 0.0177 -86.98 0.0694 -69.44 32768 20.8777 92.52 0.0494 -46.03 0.0112 -91.72 0.0606 -73.31 16 rows selected. SQL> l 1* select * from logsync_results SQL> / Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 1 900000 1 77.95215 80.554753 120.83 82.584366 1 2 900000 1 78.062133 80.560752 116.88 81.892074 1 3 900000 1 80.951694 83.477309 119.21 82.680232 1 4 900000 1 79.967842 82.591442 118.5 82.698276 1 5 900000 1 79.148968 81.721574 119.3 82.816884 1 6 900000 1 78.701035 81.487607 121.31 83.134133 1 7 900000 1 80.12582 82.877396 121.51 82.99424 1 8 900000 1 78.207111 80.915696 123.51 83.441609 1 9 900000 1 78.855012 81.471608 123.28 83.258833 1 10 900000 1 77.661193 80.190805 117.71 81.837145 1 11 900000 1 80.462767 83.209348 125.59 83.664589 1 12 900000 1 79.099975 81.783564 122.49 82.743537 1 13 900000 1 78.521062 81.027681 123.63 83.241459 1 14 900000 1 79.537908 82.066521 124.92 83.494816 1 15 900000 1 80.404777 82.93039 126.59 83.429811 1 16 900000 1 79.380932 82.034525 122.87 82.437684 1 17 900000 1 79.686885 83.156353 121.78 83.638464 1 18 900000 1 78.691038 82.2145 134.87 83.775742 1 19 900000 1 79.059981 82.431464 121.68 83.047306 1 20 900000 1 79.947845 83.459309 119.23 83.026558 1 21 900000 1 81.113669 84.256188 117.42 82.852478 1 22 900000 1 80.616745 83.157357 121.05 82.30819 1 23 900000 1 79.284946 81.824557 125.39 82.49058 1 24 900000 1 79.448922 82.974384 119.7 82.714963 1 25 900000 1 79.378933 82.945384 121.74 82.883565 1 26 900000 1 79.585902 83.051371 121.8 82.672291 1 27 900000 1 78.987992 82.617439 124.03 83.14651 1 28 900000 1 79.905853 82.753418 125.66 83.4474 1 29 900000 1 80.437771 83.220344 127.22 82.906195 1 30 900000 1 78.023139 80.658735 121.13 83.792839 1 31 900000 1 78.371085 80.907699 122.56 83.430675 1 32 900000 1 80.492763 83.12736 121.04 82.312441 1 33 900000 1 79.655891 83.155357 119.03 84.049708 1 34 900000 1 79.501915 82.913395 116.38 83.546661 1 35 900000 1 79.368934 82.910392 120.32 82.415553 1 1 900000 2 62.973427 65.805994 95.25 64.677147 1 2 900000 2 61.739614 64.502192 93.92 64.793848 1 3 900000 2 62.516496 65.339066 92.11 65.146385 1 4 900000 2 61.150704 63.895283 96.43 65.659416 1 5 900000 2 62.607482 65.613025 99.87 64.113368 1 6 900000 2 62.337523 65.130096 93.95 64.639524 1 7 900000 2 62.011573 64.766153 93.52 64.761883 1 8 900000 2 61.420663 64.246232 93.31 65.053833 1 9 900000 2 62.385516 65.151093 91.66 64.267321 1 10 900000 2 61.508649 64.287222 94.9 64.899806 1 11 900000 2 62.774457 65.481045 96.18 64.942327 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 12 900000 2 61.427661 63.560335 103.21 65.67051 1 13 900000 2 62.771457 64.98612 98.76 66.236549 1 14 900000 2 63.918283 66.076953 92.28 65.133397 1 15 900000 2 61.717618 63.831294 94.26 65.341123 1 16 900000 2 62.331525 64.91513 113.67 66.632622 1 17 900000 2 63.141401 66.047958 98.33 65.480338 1 18 900000 2 63.179394 66.021959 97.2 64.389656 1 19 900000 2 62.204544 65.117098 95.13 64.43726 1 20 900000 2 61.946582 64.687161 94.38 64.705337 1 21 900000 2 61.89659 64.672167 96.5 64.681818 1 22 900000 2 61.938584 64.692163 96.62 64.635577 1 23 900000 2 62.160551 64.995121 97.13 64.627572 1 24 900000 2 62.333525 65.158094 95.83 64.521131 1 25 900000 2 63.771305 66.636869 95.61 64.845627 1 26 900000 2 61.415664 64.209241 97.19 65.16047 1 27 900000 2 62.319526 65.23408 94.69 64.359803 1 28 900000 2 62.713465 65.542032 102.28 66.05437 1 29 900000 2 62.218542 64.98512 94.85 64.397848 1 30 900000 2 61.711618 64.585178 95.86 64.719599 1 31 900000 2 61.341675 64.061262 95.66 65.50471 1 32 900000 2 61.521648 64.353214 97.5 65.19205 1 33 900000 2 62.30253 65.106103 95.48 64.547641 1 34 900000 2 63.892287 66.731855 95.74 64.847796 1 35 900000 2 62.279532 65.074108 95.77 64.311145 1 1 900000 4 52.55401 55.035628 80.46 54.812732 1 2 900000 4 51.498172 53.917805 83.18 55.939134 1 3 900000 4 52.211062 54.601698 82.18 55.38837 1 4 900000 4 52.16007 54.635693 81.06 55.159198 1 5 900000 4 52.254056 54.755672 81.05 55.022679 1 6 900000 4 54.241754 56.673382 80.56 54.902177 1 7 900000 4 53.778824 56.31344 79.63 54.649807 1 8 900000 4 52.376038 54.836666 82.2 55.837624 1 9 900000 4 51.651149 54.096771 78.52 54.554877 1 10 900000 4 53.930802 56.387428 83.32 55.54301 1 11 900000 4 53.693837 56.134465 83.03 55.759757 1 12 900000 4 52.306048 54.77067 81.11 55.195311 1 13 900000 4 52.226061 54.717682 84.06 55.40557 1 14 900000 4 52.731984 55.193607 78 54.974939 1 15 900000 4 51.602156 53.596852 95.32 57.943922 1 16 900000 4 53.709835 56.271442 81.09 55.181607 1 17 900000 4 52.389035 54.872658 80.65 55.001743 1 18 900000 4 52.384036 54.854659 83.8 56.049715 1 19 900000 4 52.333043 54.828661 82.02 55.313781 1 20 900000 4 51.624151 54.045782 79.41 55.70025 1 21 900000 4 53.995791 56.403424 80.34 55.43012 1 22 900000 4 54.796669 56.802362 80.56 54.961426 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 23 900000 4 52.960949 54.93065 84.33 56.595117 1 24 900000 4 53.259904 55.11762 80.35 55.28778 1 25 900000 4 53.822817 55.632539 81.74 55.63829 1 26 900000 4 52.746981 54.45172 81.24 54.564672 1 27 900000 4 52.588005 54.339739 81.72 55.170968 1 28 900000 4 53.009942 55.480562 84.24 54.633181 1 29 900000 4 52.377037 54.893652 84.3 55.313349 1 30 900000 4 52.293051 54.646689 83.17 55.565327 1 31 900000 4 54.415728 56.901348 79.97 55.120334 1 32 900000 4 54.313743 56.700379 79.97 55.360431 1 33 900000 4 52.527014 54.896653 84.34 55.141344 1 34 900000 4 53.170916 55.115619 86.67 56.756215 1 35 900000 4 52.445027 54.64269 84.04 55.212396 1 1 900000 8 49.3355 51.2862 80.55 51.64856 1 2 900000 8 48.970555 50.680292 80.04 50.618792 1 3 900000 8 47.645757 49.547466 77.57 51.326756 1 4 900000 8 49.140529 50.845269 79.23 52.642369 1 5 900000 8 49.3405 50.986249 82.17 51.749104 1 6 900000 8 47.507778 49.716441 77.31 50.197877 1 7 900000 8 48.712595 50.963252 75.53 49.910336 1 8 900000 8 48.236667 50.689295 74.22 50.34639 1 9 900000 8 48.171676 50.36834 78.56 50.60526 1 10 900000 8 49.079539 51.326199 73.37 49.810202 1 11 900000 8 47.734743 49.953404 74.44 50.038955 1 12 900000 8 48.776585 51.044237 76.18 49.713128 1 13 900000 8 50.200368 52.14407 76.19 50.79409 1 14 900000 8 47.967708 49.819425 82.88 50.975434 1 15 900000 8 47.728744 49.368497 76.2 50.992213 1 16 900000 8 48.839575 51.09023 73 50.376999 1 17 900000 8 48.011701 50.333346 77.67 51.171094 1 18 900000 8 48.424638 50.614304 74.89 50.412647 1 19 900000 8 48.327654 50.589306 75.64 50.719215 1 20 900000 8 48.737591 50.935255 75.45 50.373776 1 21 900000 8 47.848725 49.547465 80.23 50.815056 1 22 900000 8 48.485629 50.219369 73.02 50.1052 1 23 900000 8 48.21967 50.535316 79.26 50.523235 1 24 900000 8 49.14353 51.440178 79.14 50.731499 1 25 900000 8 48.616609 50.821276 79.01 50.212294 1 26 900000 8 48.353649 50.735282 85.24 51.437747 1 27 900000 8 48.957557 51.263204 74.85 49.854931 1 28 900000 8 49.031546 51.408184 77.5 50.608256 1 29 900000 8 49.652452 51.986096 78.53 51.221678 1 30 900000 8 49.702444 51.868114 72.47 50.289356 1 31 900000 8 48.427638 50.658296 73.05 50.457574 1 32 900000 8 48.823578 51.054236 74.94 50.032397 1 33 900000 8 48.526623 50.756284 76.53 50.405165 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 34 900000 8 48.372646 50.624304 74.11 50.484061 1 35 900000 8 48.706597 50.857269 74.87 50.154224 1 1 900000 16 46.160982 48.395641 73.18 48.662145 1 2 900000 16 45.551076 47.852725 70 47.91698 1 3 900000 16 45.027155 47.151831 69.04 47.362297 1 4 900000 16 46.681903 48.941558 68.7 47.514191 1 5 900000 16 47.373798 49.696442 69.52 47.570232 1 6 900000 16 46.50093 48.841574 70.13 47.803384 1 7 900000 16 44.628215 46.937858 70.1 47.748399 1 8 900000 16 46.418943 48.830575 71.71 48.010635 1 9 900000 16 44.721202 46.919865 70.03 47.73097 1 10 900000 16 44.636215 46.874873 69.35 47.613926 1 11 900000 16 46.824882 49.14053 68.9 47.677908 1 12 900000 16 45.951015 48.224668 67.24 47.251005 1 13 900000 16 46.316959 48.703592 69.18 48.420221 1 14 900000 16 46.156983 48.424638 72 48.104961 1 15 900000 16 46.147984 48.443633 73.87 48.273607 1 16 900000 16 46.680903 48.990552 68.6 47.346582 1 17 900000 16 46.695901 48.862571 71.19 47.971645 1 18 900000 16 46.494932 48.836576 72.43 48.019941 1 19 900000 16 46.514929 48.796581 68.77 47.755655 1 20 900000 16 46.577919 48.802581 69.08 48.072985 1 21 900000 16 46.192979 48.485629 68.26 48.019109 1 22 900000 16 46.395946 48.631604 70.66 47.928458 1 23 900000 16 46.468936 48.651605 68.63 47.889492 1 24 900000 16 46.594916 48.540618 70.97 48.392864 1 25 900000 16 45.97901 48.172674 70.75 48.539228 1 26 900000 16 45.953014 48.289659 70.95 48.302983 1 27 900000 16 44.752198 46.951863 69.26 47.659303 1 28 900000 16 46.762891 49.00255 71.25 48.542894 1 29 900000 16 46.470935 48.740589 69.63 47.955505 1 30 900000 16 46.284964 48.473629 75.21 48.284743 1 31 900000 16 46.714898 49.006549 74.1 47.870714 1 32 900000 16 45.149136 47.399793 69.17 47.380341 1 33 900000 16 46.548923 48.916561 69.83 47.661521 1 34 900000 16 44.887176 47.183827 80.34 49.449457 1 35 900000 16 46.381948 48.738589 69.76 47.967457 1 1 900000 32 44.270269 47.143832 23.43 44.89963 1 2 900000 32 44.288267 47.311804 23.99 44.934782 1 3 900000 32 44.384253 47.262813 23.58 45.012722 1 4 900000 32 46.406946 49.3455 23.05 44.969363 1 5 900000 32 44.986161 47.907714 22.88 45.084385 1 6 900000 32 44.33326 47.285809 25.3 45.026958 1 7 900000 32 44.27027 47.150831 23.29 44.963285 1 8 900000 32 44.114293 46.926864 23.41 44.893192 1 9 900000 32 44.252272 47.169826 23.64 44.963885 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 10 900000 32 44.323261 47.346797 25.66 44.924607 1 11 900000 32 44.366255 47.291807 23.55 44.899967 1 12 900000 32 44.135291 46.99785 24.57 44.94623 1 13 900000 32 44.116294 47.071845 24.97 44.943993 1 14 900000 32 44.307264 47.102839 23.91 45.036166 1 15 900000 32 44.363256 47.21082 23.59 44.930161 1 16 900000 32 44.448242 47.269808 23.01 44.939289 1 17 900000 32 46.172982 48.61561 23.04 45.102022 1 18 900000 32 44.310265 46.38695 22.82 45.052702 1 19 900000 32 44.003311 46.240966 22.89 45.103527 1 20 900000 32 44.00931 46.174977 23.18 45.167296 1 21 900000 32 44.064301 46.31096 22.71 45.334894 1 22 900000 32 43.900327 46.080992 22.5 45.336044 1 23 900000 32 44.057302 46.096992 23.05 45.132604 1 24 900000 32 44.065301 46.103989 23.01 45.196283 1 25 900000 32 46.146986 48.337651 22.68 45.128572 1 26 900000 32 44.27027 46.35195 21.53 45.126667 1 27 900000 32 46.047 48.378646 24.34 45.317843 1 28 900000 32 44.063302 46.21597 22.75 45.057106 1 29 900000 32 45.493084 47.615763 23.12 45.048871 1 30 900000 32 44.145288 46.212973 21.98 44.932074 1 31 900000 32 45.036154 47.207822 22.87 45.02864 1 32 900000 32 46.496931 48.657599 23.32 44.971534 1 33 900000 32 44.355257 46.681905 24.91 45.177607 1 34 900000 32 44.127291 46.220971 23.67 44.89024 1 35 900000 32 44.323261 47.278811 23.16 45.172131 1 1 900000 64 44.080299 46.318955 14.38 44.465533 1 2 900000 64 44.235275 45.887021 14.61 44.457818 1 3 900000 64 44.108295 45.729048 14.79 44.418553 1 4 900000 64 44.228277 45.821033 14.04 44.396798 1 5 900000 64 45.700052 47.162831 36.34 45.224956 1 6 900000 64 44.294266 46.528924 14.34 44.412635 1 7 900000 64 44.552227 46.883874 15.02 44.373441 1 8 900000 64 44.098297 46.336955 15.64 44.403411 1 9 900000 64 44.372255 46.650905 14.75 44.439924 1 10 900000 64 44.097296 46.849875 26.41 44.513142 1 11 900000 64 44.289267 46.371951 14.74 44.442018 1 12 900000 64 44.372254 46.667901 15.63 44.556898 1 13 900000 64 44.172285 46.47993 15.28 44.379277 1 14 900000 64 44.135291 46.309962 15.63 44.336206 1 15 900000 64 44.202281 46.492933 16.25 44.459405 1 16 900000 64 44.321263 46.502932 14.96 44.433299 1 17 900000 64 44.371254 46.484934 15.23 44.424234 1 18 900000 64 44.105295 46.334955 15.23 44.51983 1 19 900000 64 44.371255 46.595915 15.17 44.482497 1 20 900000 64 44.317263 46.579917 15.46 44.411376 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 21 900000 64 42.883481 44.52323 14.61 44.551256 1 22 900000 64 44.362256 46.680903 16.26 44.41115 1 23 900000 64 44.39925 46.609914 15.37 44.394805 1 24 900000 64 44.404249 46.581917 14.13 44.432904 1 25 900000 64 43.15044 45.3591 15.03 44.444692 1 26 900000 64 44.147287 46.451937 15.58 44.401932 1 27 900000 64 44.098296 46.316958 15.05 44.445451 1 28 900000 64 44.160288 46.428941 15.64 44.459445 1 29 900000 64 44.20328 46.43294 15.09 44.427493 1 30 900000 64 44.158287 46.517928 15.33 44.473252 1 31 900000 64 44.148288 46.338953 14.1 44.419217 1 32 900000 64 44.241273 46.42594 14.54 44.368665 1 33 900000 64 44.456241 46.722892 14.75 44.433259 1 34 900000 64 44.383253 46.558922 14.67 44.416313 1 35 900000 64 44.316263 46.524924 14.42 44.417182 1 1 900000 128 43.529383 45.357104 10.44 44.271126 1 2 900000 128 44.187283 45.98001 10.58 44.205782 1 3 900000 128 43.08545 44.913169 11.33 44.303793 1 4 900000 128 44.320262 46.266963 11.44 44.365115 1 5 900000 128 45.201128 47.014852 10.85 44.286863 1 6 900000 128 44.33426 46.148982 10.21 44.327888 1 7 900000 128 44.339259 46.202973 10.67 44.392028 1 8 900000 128 44.320263 46.130985 10.86 44.300179 1 9 900000 128 44.101295 45.572069 10.42 44.492199 1 10 900000 128 43.952318 45.348103 10.64 44.479604 1 11 900000 128 44.049304 45.58707 10.85 44.564604 1 12 900000 128 43.015461 44.391253 11.36 44.403339 1 13 900000 128 44.330261 46.180977 10.73 44.313478 1 14 900000 128 44.089297 45.920016 11.09 44.198625 1 15 900000 128 44.273269 46.037001 10.54 44.481706 1 16 900000 128 42.903478 44.532231 60.53 47.892519 1 17 900000 128 45.336108 47.235818 11.58 44.346881 1 18 900000 128 44.223277 46.053997 11.51 44.293335 1 19 900000 128 45.383101 47.308807 11.39 44.275561 1 20 900000 128 44.057303 45.989008 10.45 44.361092 1 21 900000 128 44.361256 46.42694 19.03 44.380761 1 22 900000 128 44.47124 46.31396 11.4 44.317668 1 23 900000 128 44.514233 46.469937 11.24 44.206816 1 24 900000 128 44.26927 46.17198 11.14 44.309261 1 25 900000 128 44.187284 45.984011 10.65 44.173926 1 26 900000 128 43.389404 45.23312 10.37 44.323135 1 27 900000 128 44.546228 46.403942 10.07 44.246344 1 28 900000 128 44.081298 45.856029 11.1 44.330251 1 29 900000 128 44.323262 46.22797 10.82 44.194871 1 30 900000 128 44.33326 46.267965 11.88 44.227909 1 31 900000 128 44.416248 46.259967 11.22 44.266989 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 32 900000 128 44.195281 46.056996 11.1 44.325817 1 33 900000 128 44.297266 46.199975 10.76 44.286216 1 34 900000 128 44.20428 46.03 10.63 44.27524 1 35 900000 128 44.311264 46.088994 11.32 44.246424 1 1 900000 256 44.038306 45.64106 9.25 43.998251 1 2 900000 256 44.299266 45.938013 9.31 43.865004 1 3 900000 256 42.319566 43.840333 9.4 43.979323 1 4 900000 256 44.369256 46.099993 9.76 43.92855 1 5 900000 256 44.207279 45.949011 10.13 43.9977 1 6 900000 256 44.044304 45.777038 9.91 43.851827 1 7 900000 256 44.176284 45.735046 8.4 43.935211 1 8 900000 256 44.228276 45.907019 8.75 43.911212 1 9 900000 256 44.143289 45.82303 9.91 43.897522 1 10 900000 256 43.953318 45.592065 8.79 43.926545 1 11 900000 256 44.254273 45.950013 9.54 43.835525 1 12 900000 256 44.371255 46.019003 9.47 43.871736 1 13 900000 256 44.13629 45.785036 8.92 43.836436 1 14 900000 256 44.126292 45.76604 9.06 43.85128 1 15 900000 256 43.919323 45.586069 8.71 43.947033 1 16 900000 256 44.093297 45.768042 9.24 43.865873 1 17 900000 256 43.981313 45.56507 9.28 43.85675 1 18 900000 256 44.200281 45.795037 9.15 43.922515 1 19 900000 256 44.001311 45.704048 10.78 44.080072 1 20 900000 256 44.032306 45.692054 9.41 43.806247 1 21 900000 256 43.876329 45.656056 8.61 44.033459 1 22 900000 256 44.055303 45.724046 8.65 43.995351 1 23 900000 256 44.152288 45.741046 8.59 43.957601 1 24 900000 256 44.255272 45.878026 9.65 43.849495 1 25 900000 256 44.111294 45.819032 8.88 43.908751 1 26 900000 256 44.26627 45.910019 9.44 43.983714 1 27 900000 256 43.673362 45.19113 28.12 46.198071 1 28 900000 256 44.228277 45.928015 11.39 43.942732 1 29 900000 256 42.453546 44.222275 9.83 44.054861 1 30 900000 256 42.310567 43.898326 9.82 44.028881 1 31 900000 256 44.066302 45.741044 9.01 43.881346 1 32 900000 256 44.031307 46.515925 22.31 44.027336 1 33 900000 256 44.040305 45.59907 10.41 44.053682 1 34 900000 256 43.529383 45.178131 9.88 43.891411 1 35 900000 256 44.00831 45.727046 9.3 44.001033 1 1 900000 512 42.150592 43.665361 8.52 43.901511 1 2 900000 512 44.341259 45.826032 8.05 43.603139 1 3 900000 512 44.219278 45.741044 8.3 43.649526 1 4 900000 512 43.386404 44.869178 8.47 43.696528 1 5 900000 512 42.235579 43.72435 8.8 43.63933 1 6 900000 512 43.263423 44.78719 9.1 43.628399 1 7 900000 512 42.488541 44.045301 8.95 43.767227 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 8 900000 512 44.324262 45.890018 8 43.666396 1 9 900000 512 42.092601 43.597372 8.46 43.687354 1 10 900000 512 44.193281 45.703052 8.14 43.688838 1 11 900000 512 42.067605 43.607368 8.99 43.722218 1 12 900000 512 44.366256 45.922019 9.31 43.79951 1 13 900000 512 44.034306 45.649059 8.85 43.909611 1 14 900000 512 44.090297 45.718047 10.37 43.819697 1 15 900000 512 43.930322 45.57907 9.45 43.733961 1 16 900000 512 41.948622 43.497388 9.55 43.86433 1 17 900000 512 44.135291 45.797037 8.75 43.593015 1 18 900000 512 44.265271 45.849026 8.82 43.811993 1 19 900000 512 42.109598 43.568378 9.12 43.691454 1 20 900000 512 42.156591 43.733348 9.97 43.696565 1 21 900000 512 42.078603 43.66236 8.66 43.633978 1 22 900000 512 42.150592 43.667358 8.95 43.816302 1 23 900000 512 44.211278 45.668057 8.68 43.73716 1 24 900000 512 43.339411 44.890172 8.86 43.758092 1 25 900000 512 44.175284 45.855028 10.07 43.790549 1 26 900000 512 44.141289 45.707052 8.69 43.739992 1 27 900000 512 42.151592 43.744348 8.36 43.804045 1 28 900000 512 44.252272 45.746043 7.92 43.679857 1 29 900000 512 44.119292 45.78704 8.8 43.788574 1 30 900000 512 44.431246 45.922021 8.59 43.684193 1 31 900000 512 41.97062 43.651363 9.91 43.852358 1 32 900000 512 44.249274 45.784039 7.72 43.734444 1 33 900000 512 44.133291 45.593069 8.68 43.682022 1 34 900000 512 42.450547 43.952315 8.83 43.74759 1 35 900000 512 43.138441 44.612213 8.06 43.676916 1 1 900000 1024 44.159287 45.681053 14.63 43.658394 1 2 900000 1024 43.457394 44.899175 14.23 43.603075 1 3 900000 1024 43.936321 45.473084 14.27 43.693789 1 4 900000 1024 42.532535 43.974314 44.45 46.4157 1 5 900000 1024 44.124292 45.584073 14.95 43.763621 1 6 900000 1024 44.13529 45.640064 16.43 43.56106 1 7 900000 1024 42.055607 43.567373 13.74 43.619944 1 8 900000 1024 42.079603 43.653362 15.09 43.670597 1 9 900000 1024 44.080299 45.770042 17.2 43.587144 1 10 900000 1024 44.260271 45.743043 14.61 43.546419 1 11 900000 1024 42.522535 44.081294 14.2 43.544611 1 12 900000 1024 43.068452 44.539229 15.24 43.541925 1 13 900000 1024 42.49254 44.025304 13.61 43.525674 1 14 900000 1024 42.213583 43.689356 13.93 43.458811 1 15 900000 1024 44.150288 45.654059 14.22 43.566781 1 16 900000 1024 42.928473 44.415246 14.39 43.643342 1 17 900000 1024 44.432245 45.995006 14.39 43.613042 1 18 900000 1024 45.002158 46.495926 13.96 43.58161 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 19 900000 1024 44.252273 45.722049 14.85 43.437929 1 20 900000 1024 44.320264 45.764044 14.72 43.480434 1 21 900000 1024 44.253272 45.856029 15.17 43.475139 1 22 900000 1024 42.145592 43.622366 14.63 43.620235 1 23 900000 1024 44.343259 45.830032 13.85 43.596193 1 24 900000 1024 42.081603 43.628366 15.33 43.608555 1 25 900000 1024 43.463392 44.954163 14.34 43.49326 1 26 900000 1024 44.355256 45.877023 14.23 43.570136 1 27 900000 1024 41.818643 43.386403 15.31 43.779563 1 28 900000 1024 44.029307 45.512081 14.15 43.608131 1 29 900000 1024 44.321262 45.928016 14.82 43.656121 1 30 900000 1024 44.360255 45.858025 15.04 43.459932 1 31 900000 1024 41.940624 43.390402 13.18 43.471283 1 32 900000 1024 44.111294 45.590068 13.76 43.479374 1 33 900000 1024 44.237275 45.711051 14.38 43.519673 1 34 900000 1024 44.123292 45.601066 15.43 43.575819 1 35 900000 1024 43.991312 45.493081 14.27 43.5163 1 1 900000 2048 44.230276 45.712047 12.77 43.594539 1 2 900000 2048 42.435549 43.893327 13.02 43.581612 1 3 900000 2048 44.0653 45.528076 13.16 43.435157 1 4 900000 2048 44.136291 45.612063 12.95 43.495768 1 5 900000 2048 44.341259 45.857028 13.3 43.439531 1 6 900000 2048 41.908628 43.327413 13.12 43.580796 1 7 900000 2048 43.971315 45.449088 13.3 43.52241 1 8 900000 2048 43.703356 45.319109 14.89 43.997841 1 9 900000 2048 42.43455 43.828336 13.37 43.4839 1 10 900000 2048 44.285267 45.777035 12.37 43.672369 1 11 900000 2048 44.26927 45.76904 12.58 43.550489 1 12 900000 2048 42.43455 43.937318 12.9 43.581996 1 13 900000 2048 43.931321 45.44109 13.87 43.677331 1 14 900000 2048 43.059454 44.549227 13.37 43.653104 1 15 900000 2048 44.027307 45.472084 15.56 43.6178 1 16 900000 2048 43.276422 44.784194 13.31 43.574454 1 17 900000 2048 42.150592 43.660361 13.94 43.585184 1 18 900000 2048 43.777344 45.259117 14.07 43.801701 1 19 900000 2048 43.976314 45.423093 13.23 43.640303 1 20 900000 2048 42.301569 44.834181 31.7 43.606715 1 21 900000 2048 44.098296 45.651059 13.15 43.60657 1 22 900000 2048 44.349258 45.895021 12.83 43.552937 1 23 900000 2048 42.371558 43.91532 12.46 43.603468 1 24 900000 2048 43.390403 44.876175 13.22 43.501535 1 25 900000 2048 42.512537 44.074296 12.64 43.456311 1 26 900000 2048 42.336563 43.750349 12.29 43.47214 1 27 900000 2048 44.059302 45.562072 12.81 43.530207 1 28 900000 2048 44.0683 45.604063 12.46 43.42429 1 29 900000 2048 44.061301 45.570071 13.97 43.418046 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 30 900000 2048 44.218278 45.628063 11.86 43.507136 1 31 900000 2048 44.151288 45.627062 12.58 43.593153 1 32 900000 2048 41.89263 43.351406 13.41 43.747172 1 33 900000 2048 44.40025 45.835032 13.22 43.5614 1 34 900000 2048 44.218278 45.77104 13.59 43.581695 1 35 900000 2048 42.384556 43.843333 12.92 43.521612 1 1 900000 4096 42.1006 43.611368 11.47 43.47775 1 2 900000 4096 42.053608 43.454395 12.12 43.562988 1 3 900000 4096 44.127292 45.629063 11.33 43.677926 1 4 900000 4096 42.263575 43.749348 11.52 43.596271 1 5 900000 4096 43.233428 44.626216 11.48 43.529443 1 6 900000 4096 43.844334 45.3701 12.53 43.713547 1 7 900000 4096 44.290266 45.772039 11.35 43.568392 1 8 900000 4096 42.295569 43.71135 11.54 43.568054 1 9 900000 4096 44.064301 45.539076 11.66 43.670687 1 10 900000 4096 45.085147 46.647908 12.53 43.578978 1 11 900000 4096 43.899326 45.389097 12.28 43.630401 1 12 900000 4096 42.172589 43.525381 12.16 43.624664 1 13 900000 4096 44.166285 45.746043 12.39 43.560346 1 14 900000 4096 44.151287 45.629059 11.34 43.57979 1 15 900000 4096 41.977619 43.451392 12.21 43.636452 1 16 900000 4096 44.069301 45.481087 12.96 43.714529 1 17 900000 4096 44.407248 45.902018 12.23 43.643878 1 18 900000 4096 42.404555 43.879331 13.16 43.632708 1 19 900000 4096 44.271269 45.657056 12.33 43.652768 1 20 900000 4096 44.212279 45.717048 12 43.679628 1 21 900000 4096 42.123596 43.681357 12.12 43.542306 1 22 900000 4096 42.109598 43.555376 11.75 43.526865 1 23 900000 4096 44.081299 45.524078 10.95 43.529663 1 24 900000 4096 44.346259 45.822032 11.22 43.606711 1 25 900000 4096 42.395555 43.88033 11.65 43.579118 1 26 900000 4096 44.050304 45.233126 11.52 43.756665 1 27 900000 4096 43.585375 44.863175 31.14 46.175821 1 28 900000 4096 43.979314 45.276116 12.73 43.93324 1 29 900000 4096 44.156287 45.466087 13.07 43.702746 1 30 900000 4096 42.077604 43.545381 12.92 43.673472 1 31 900000 4096 44.036307 45.603066 11.45 43.613308 1 32 900000 4096 43.851333 46.41794 29.28 43.865889 1 33 900000 4096 41.989616 43.115448 12 43.671248 1 34 900000 4096 41.958621 43.177431 12.44 43.748913 1 35 900000 4096 44.34026 45.557074 11.58 43.564431 1 1 900000 8192 44.183283 45.450089 11.17 43.668561 1 2 900000 8192 42.49554 43.591374 10.41 43.501774 1 3 900000 8192 44.049303 45.222122 10.31 43.521535 1 4 900000 8192 42.200585 43.3984 9.82 43.438417 1 5 900000 8192 42.140593 43.493388 10.11 43.472346 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 6 900000 8192 44.037304 45.501079 10.49 43.555427 1 7 900000 8192 44.315264 45.766044 11.52 43.392759 1 8 900000 8192 41.892632 43.300416 10.9 43.653897 1 9 900000 8192 44.249273 45.70405 10.67 43.427107 1 10 900000 8192 44.00131 45.505082 11.74 43.528068 1 11 900000 8192 44.299267 45.84703 9.76 43.435157 1 12 900000 8192 41.988617 43.360411 11.07 43.461134 1 13 900000 8192 44.093296 45.617061 11.08 43.377606 1 14 900000 8192 42.915477 44.404247 10.51 43.64202 1 15 900000 8192 44.257272 45.711048 10.37 43.528599 1 16 900000 8192 42.027611 43.47939 11.12 43.50416 1 17 900000 8192 43.948319 45.545072 10.65 43.718535 1 18 900000 8192 42.29157 43.771343 10.29 43.438984 1 19 900000 8192 42.332563 43.749348 10.59 43.364297 1 20 900000 8192 43.767347 45.225123 10.9 43.553949 1 21 900000 8192 42.028611 43.497388 11.03 43.438656 1 22 900000 8192 43.051456 44.516232 10.11 43.488062 1 23 900000 8192 41.938625 43.327415 10.83 43.4503 1 24 900000 8192 44.009309 45.479085 10.14 43.487678 1 25 900000 8192 44.306265 45.90402 11.73 43.565613 1 26 900000 8192 41.980619 43.334414 10.6 43.549361 1 27 900000 8192 41.83764 43.251423 10.9 43.581989 1 28 900000 8192 42.076603 43.521382 11.25 43.394176 1 29 900000 8192 43.327412 44.809184 10.64 43.419719 1 30 900000 8192 42.282572 43.683356 10.61 43.436688 1 31 900000 8192 42.978466 44.336257 12.02 43.776426 1 32 900000 8192 44.109294 45.378099 11.38 43.756189 1 33 900000 8192 43.974314 45.172132 10.07 43.70663 1 34 900000 8192 43.690359 44.888178 9.8 43.866546 1 35 900000 8192 44.240275 45.70405 10.37 43.453561 1 1 900000 16384 44.33526 45.820034 9.41 42.852025 1 2 900000 16384 44.054303 45.415097 10.08 42.90396 1 3 900000 16384 43.904326 45.067146 9.78 43.186169 1 4 900000 16384 42.303569 43.503385 9.56 43.036824 1 5 900000 16384 42.446547 43.586372 9.08 42.985874 1 6 900000 16384 41.96262 43.179431 9.62 43.020115 1 7 900000 16384 42.056607 43.254422 9.17 42.966835 1 8 900000 16384 42.119597 49.080538 45.31 44.156141 1 9 900000 16384 44.392251 51.69314 44.78 45.00599 1 10 900000 16384 44.120292 51.046239 35.47 43.310555 1 11 900000 16384 43.938321 53.14892 55.55 43.666865 1 12 900000 16384 43.819339 82.730423 21.06 43.3612 1 13 900000 16384 43.997311 45.363104 9.13 43.241007 1 14 900000 16384 44.455241 46.009003 9.65 43.149126 1 15 900000 16384 44.065302 45.603063 10.74 43.491953 1 16 900000 16384 43.972315 45.468086 10.34 43.160897 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 17 900000 16384 42.420551 43.828337 10.92 43.133561 1 18 900000 16384 43.183435 44.617214 9.64 43.204274 1 19 900000 16384 42.467544 43.893326 9.66 43.105571 1 20 900000 16384 42.22658 43.570376 9.88 43.045071 1 21 900000 16384 42.29457 43.699356 8.92 43.062975 1 22 900000 16384 42.252577 43.802341 10.62 43.058306 1 23 900000 16384 42.046608 43.523383 9.67 43.133974 1 24 900000 16384 42.222582 43.584373 9.61 43.089227 1 25 900000 16384 43.21343 44.656206 9.69 43.083962 1 26 900000 16384 44.163286 45.598065 8.94 43.115638 1 27 900000 16384 43.883329 45.466086 11.84 43.185631 1 28 900000 16384 42.395555 50.147375 69.76 45.106636 1 29 900000 16384 43.901326 45.359102 9.17 43.23723 1 30 900000 16384 43.937321 45.522077 10.07 43.287639 1 31 900000 16384 43.911325 45.309114 10.27 43.241107 1 32 900000 16384 44.079299 45.513079 10.08 43.161255 1 33 900000 16384 41.486694 42.990462 9.69 43.048568 1 34 900000 16384 42.391556 43.793343 9.03 43.055621 1 35 900000 16384 43.268422 44.687206 9.83 43.102838 1 1 900000 32768 44.148288 45.708052 11.31 43.300448 1 2 900000 32768 43.877329 45.349104 9.23 43.186227 1 3 900000 32768 42.787494 44.361254 9.61 43.17564 1 4 900000 32768 42.099601 43.509387 8.99 42.937701 1 5 900000 32768 41.883633 43.379405 10.37 43.032906 1 6 900000 32768 42.250578 43.731348 9.52 43.028552 1 7 900000 32768 44.094297 45.534077 8.86 43.138335 1 8 900000 32768 44.408248 46.035998 10.01 43.305974 1 9 900000 32768 43.931321 45.50008 11.22 43.176008 1 10 900000 32768 44.024306 45.549073 10.44 43.162213 1 11 900000 32768 42.209584 43.586376 8.36 43.020554 1 12 900000 32768 42.098601 43.580375 10.44 43.12353 1 13 900000 32768 42.415551 43.859329 8.43 43.001216 1 14 900000 32768 41.965621 43.461392 9.08 43.117912 1 15 900000 32768 41.918627 43.329412 13.07 43.575543 1 16 900000 32768 41.896631 43.466391 10.71 43.321429 1 17 900000 32768 42.263576 43.741348 9.77 43.11094 1 18 900000 32768 42.248578 43.67936 9.4 43.269032 1 19 900000 32768 42.542532 43.978313 9.39 43.060199 1 20 900000 32768 43.123445 44.898175 11.32 43.058543 1 21 900000 32768 44.211279 46.494933 18.57 43.061871 1 22 900000 32768 42.465544 43.930319 9.61 42.975634 1 23 900000 32768 42.402553 43.919321 9.48 43.089042 1 24 900000 32768 42.015613 43.522383 9.59 43.191059 1 25 900000 32768 42.30557 43.749352 9.51 42.932313 1 26 900000 32768 44.218278 45.793037 9.15 43.09868 1 27 900000 32768 42.515537 43.946317 9.54 42.956321 Total Batch TEST_ID SAMPLE Rows Size MY_CPU_TIME_S SYS_CPU_TIME_S SYS_WAIT_TIME_S ELAPSED_TIME_S TOT_BLK_CHANGES ---------- ---------- ------- ------ ------------- -------------- --------------- -------------- --------------- 1 28 900000 32768 42.304569 43.894326 9.91 42.978477 1 29 900000 32768 42.030609 43.486387 9.97 42.956583 1 30 900000 32768 42.368559 43.891326 9.65 42.98436 1 31 900000 32768 43.34841 44.865178 10.23 42.940574 1 32 900000 32768 42.526535 43.971315 9.33 42.934831 1 33 900000 32768 44.038305 45.494084 8.75 43.204379 1 34 900000 32768 44.216278 45.591066 10.72 43.374915 1 35 900000 32768 44.281269 45.886022 10.08 43.020377 560 rows selected.