Data collected on June 3, 2011 on OraPub's FourCore Linux server running Oracle 11.2.

---------------------------------
Initial Baseline Results
---------------------------------

SAMPLE_NO||','||ELAPSED_S||','||LIO||','||CR||','||WAIT_TIME_S||','||SYS_CPU_S
--------------------------------------------------------------------------------------------------------------------------
1,2.665446,308063,308007,.95,1.199817,
2,2.649288,308007,308007,1.96,4.061382,
3,2.664593,308007,308007,.94,2.004694,
4,2.649002,308010,308007,.95,4.017389,
5,2.664373,308010,308010,.94,2.004695,
6,2.648268,308007,308007,.95,4.028388,
7,2.663974,308010,308010,.95,2.019692,
8,2.658769,308007,308007,.94,4.036388,
9,2.664276,308084,308084,.94,2.009693,
10,2.648222,308010,308010,.96,4.01539,
11,2.665311,308007,308007,.94,2.012694,
12,2.649241,308010,308010,.94,4.021388,
13,2.663618,308007,308007,.95,2.019694,
14,2.645305,308010,308010,.94,2.018693,
15,2.665279,308010,308010,.94,2.013693,
16,2.64943,308007,308007,.95,2.007695,
17,2.664447,308010,308010,.95,4.014391,
18,2.647636,308007,308007,.94,2.015693,
19,2.664117,308010,308010,.95,4.010391,
20,2.648084,308007,308007,.95,2.018693,
21,2.66066,308010,308007,.94,4.026388,
22,2.648495,308010,308010,.94,2.004694,
23,2.665028,308007,308007,.94,4.037387,
24,2.647572,308010,308010,.95,2.018693,
25,2.663154,308007,308007,.94,4.019389,
26,2.647078,308010,308010,.94,2.007694,
27,2.668176,322656,328011,.99,2.028692,
28,2.648891,312565,310444,.96,2.672592,
29,2.670773,308046,308046,.95,2.023693,
30,2.651396,308007,308007,.94,4.037387,
31,2.667359,308010,308010,.95,2.015693,
32,2.652045,308010,308010,.95,4.00839,
33,2.667493,308007,308007,.94,2.003696,
34,2.651687,308010,308010,.94,4.026388,
35,2.669689,308007,308007,.95,2.021693,
36,2.653012,308010,308010,.94,4.037386,
37,2.667307,308007,308007,.95,2.009695,
38,2.648275,308010,308007,.94,4.00739,
39,2.663538,308010,308010,.95,2.016693,
40,2.652308,308007,308007,.94,4.025388,
41,2.66717,308010,308010,.94,2.019693,
42,2.65166,308007,308007,.95,2.018694,
43,2.667773,308010,308010,.94,2.012694,
44,2.652023,308010,308010,.94,2.005695,
45,2.665902,308007,308007,.95,4.016389,
46,2.651422,308010,308010,.94,2.024691,
47,2.666985,308007,308007,.94,4.013391,
48,2.652746,308326,308303,.97,2.08168,
49,2.666254,308046,308046,.95,4.034388,
50,2.650931,308007,308007,.94,2.007693,
51,2.669036,308021,308021,.94,4.027386,
52,2.651489,308007,308007,.95,2.028693,
53,2.666471,308010,308010,.94,4.018389,
54,2.650807,308007,308007,.95,2.007695,
55,2.666709,308010,308007,.94,4.006391,
56,2.650657,308010,308010,.95,2.013694,
57,2.663523,308007,308007,.94,2.017693,
58,2.64851,308010,308010,.94,2.019693,
59,2.663745,308007,308007,.95,2.018694,
60,2.649734,308010,308010,.94,4.006391

60 rows selected.

---------------------------------
Results after first 1M row 2x update without commit
---------------------------------

SAMPLE_NO||','||ELAPSED_S||','||LIO||','||CR||','||WAIT_TIME_S||','||SYS_CPU_S
--------------------------------------------------------------------------------------------------------------------------
1,3.994913,1426806,1426806,1.12,3.891409,
2,4.006151,1426809,1426809,2.13,4.013389,
3,4.001883,1427154,1427131,1.15,4.122371,
4,3.999369,1428446,1428446,1.13,4.026388,
5,4.004718,1426809,1426809,1.11,4.069382,
6,3.995805,1426806,1426806,1.1,4.029387,
7,4.002537,1426809,1426806,1.11,4.008391,
8,3.995605,1426809,1426809,1.12,4.01739,
9,4.002827,1426809,1426809,1.11,4.038386,
10,3.998018,1426809,1426809,1.11,4.029387,
11,4.003628,1426809,1426809,1.1,4.00939,
12,4.001707,1426809,1426809,1.13,4.01739,
13,4.001838,1426806,1426806,1.1,4.044386,
14,3.993943,1426809,1426806,1.11,4.037385,
15,4.001831,1426809,1426809,1.12,4.009391,
16,3.994702,1426809,1426809,1.1,4.022388,
17,4.017689,1427125,1427102,1.15,4.070379,
18,3.990551,1426845,1426845,1.13,4.02039,
19,3.999733,1426809,1426809,1.11,4.026386,
20,3.989505,1426806,1426806,1.1,4.040387,
21,3.998662,1426809,1426806,1.11,4.036386,
22,3.988268,1426812,1426812,1.12,6.010086,
23,3.995825,1426809,1426809,1.11,4.033387,
24,3.990166,1426809,1426809,1.11,4.036386,
25,3.99578,1426809,1426809,1.1,4.039387,
26,3.990207,1426809,1426809,1.12,4.010391,
27,3.996167,1426806,1426806,1.1,4.019389,
28,3.986059,1426809,1426806,1.11,4.030386,
29,4.003529,1426809,1426809,1.13,5.038235,
30,3.985971,1426820,1426820,1.1,4.025388,
31,4.014982,1427152,1427129,1.13,4.099375,
32,3.982825,1426845,1426845,1.12,4.030388,
33,3.989668,1426809,1426809,1.1,4.012391,
34,3.987856,1426806,1426806,1.11,4.028386,
35,3.9894,1426809,1426809,1.1,4.035387,
36,3.979361,1426809,1426809,1.16,4.026389,
37,3.990222,1426809,1426809,1.11,4.017389,
38,3.987401,1426809,1426809,1.1,4.037386,
39,3.997128,1426809,1426809,1.12,4.009391,
40,3.986928,1426809,1426809,1.1,4.022388,
41,3.996353,1426806,1426806,1.11,4.032387,
42,3.988266,1426809,1426809,1.1,4.037386,
43,3.99716,1426809,1426809,1.11,4.01339,
44,3.995825,1426809,1426809,1.12,4.006392,
45,4.002935,1426809,1426809,2.12,4.030386,
46,4.011382,1427127,1427104,1.12,4.093375,
47,4.009367,1426806,1426806,1.11,4.031385,
48,3.988397,1426848,1426848,1.11,4.042386,
49,3.994342,1426809,1426809,1.1,6.033083,
50,3.990078,1426809,1426809,1.12,4.008392,
51,3.996685,1426809,1426809,1.12,4.024386,
52,3.989147,1426809,1426809,1.1,4.027388,
53,4.001707,1427111,1427094,1.13,4.054382,
54,3.993829,1426806,1426806,1.11,4.032387,
55,3.996428,1426845,1426845,1.11,4.040386,
56,3.981841,1426809,1426809,1.1,4.019389,
57,3.991456,1426809,1426809,1.11,6.012087,
58,3.987057,1426908,1426867,1.16,4.062382,
59,3.987529,1426809,1426809,1.12,4.048385,
60,3.981312,1426806,1427129,1.1,4.050385

60 rows selected.

---------------------------------
Results after second 1M row 2x update without commit
---------------------------------


SAMPLE_NO||','||ELAPSED_S||','||LIO||','||CR||','||WAIT_TIME_S||','||SYS_CPU_S
--------------------------------------------------------------------------------------------------------------------------
1,4.424074,1545609,1545609,1.22,3.941401,
2,4.392421,1545609,1545609,1.21,4.037386,
3,4.399094,1545612,1545612,1.2,6.034083,
4,4.393679,1545609,1545609,1.22,4.019388,
5,4.400687,1545609,1545609,1.21,4.034388,
6,4.404907,1545925,1545902,1.25,6.115068,
7,4.406878,1545645,1545645,1.22,4.025388,
8,4.384741,1545609,1545609,1.19,4.038387,
9,4.389897,1545606,1545609,1.24,6.037082,
10,4.383766,1545606,1545606,1.2,4.009391,
11,4.403445,1545609,1545609,1.2,4.021387,
12,4.390292,1545609,1545609,1.22,4.037387,
13,4.396691,1545609,1545609,1.2,4.014389,
14,4.386173,1545609,1545609,1.2,4.01239,
15,4.394528,1545609,1545609,1.2,4.026388,
16,4.386357,1545609,1545609,1.21,4.037387,
17,4.393605,1545620,1545620,1.27,4.033386,
18,4.383038,1545609,1545609,1.2,4.032388,
19,4.399999,1549193,1548540,1.46,4.235352,
20,4.386999,1545645,1545645,1.38,4.035386,
21,4.394332,1545609,1545609,1.22,4.01839,
22,4.382025,1545609,1545609,1.2,4.040387,
23,4.392783,1545609,1545609,1.21,4.015389,
24,4.38452,1545609,1545609,1.21,4.01439,
25,4.391248,1545606,1545606,1.22,3.03254,
26,4.383775,1545609,1545606,1.19,6.053079,
27,4.38902,1545612,1545612,1.21,4.019388,
28,4.384393,1545609,1545609,1.21,4.009391,
29,4.39149,1545609,1545609,1.2,6.030081,
30,4.382532,1545786,1545684,1.25,4.060384,
31,4.391035,1545609,1545609,1.22,4.018389,
32,4.383403,1545925,1545902,1.23,6.110067,
33,4.38955,1545645,1545645,1.21,4.01839,
34,4.381366,1545609,1545609,1.19,4.038385,
35,4.386887,1545609,1545609,1.21,6.031083,
36,4.383748,1545609,1545609,1.22,4.044385,
37,4.387077,1545609,1545609,1.2,4.018387,
38,4.381668,1545609,1545609,1.22,4.012392,
39,4.388551,1545609,1545609,1.2,4.030387,
40,4.383149,1545606,1545606,1.21,4.040385,
41,4.396971,1545609,1545606,1.19,4.008393,
42,4.388088,1545609,1545609,1.22,4.01239,
43,4.392166,1545609,1545609,1.2,4.043385,
44,4.387094,1545613,1545612,1.21,4.038385,
45,4.391766,1545952,1545929,1.25,4.091377,
46,4.389101,1545645,1545645,1.21,4.026389,
47,4.386503,1545609,1545609,1.21,4.014389,
48,4.382439,1545609,1545609,1.19,4.030387,
49,4.390114,1545612,1545612,1.21,4.024388,
50,4.378622,1545609,1545609,1.2,4.036387,
51,4.392265,1545609,1545609,1.21,6.022085,
52,4.381877,1545609,1545609,1.21,4.01539,
53,4.38758,1545609,1545609,1.21,4.035385,
54,4.379999,1545609,1545609,1.19,6.053081,
55,4.390579,1545606,1545620,1.2,4.007391,
56,4.380949,1545606,1545606,1.22,4.029386,
57,4.393143,1545609,1545609,1.19,6.039082,
58,4.397685,1545925,1545902,1.27,4.102375,
59,4.39283,1545645,1545645,1.21,4.02139,
60,4.383326,1545609,1545609,1.21,6.044081

60 rows selected.

---------------------------------
Results after third 1M row 2x update without commit
---------------------------------

SAMPLE_NO||','||ELAPSED_S||','||LIO||','||CR||','||WAIT_TIME_S||','||SYS_CPU_S
--------------------------------------------------------------------------------------------------------------------------
1,4.837948,1664409,1664409,1.31,3.522464,
2,4.92158,1664409,1664409,1.31,6.038084,
3,4.917782,1664409,1664409,1.31,4.023388,
4,4.918257,1664412,1664412,1.3,4.042386,
5,4.918984,1664409,1664409,1.31,6.040081,
6,4.923956,1664757,1664732,1.33,4.125371,
7,4.915615,1664445,1664445,1.31,6.019084,
8,4.917604,1664409,1664409,1.3,4.033387,
9,4.918637,1664409,1664409,1.3,6.060078,
10,4.918761,1664409,1664409,1.3,6.017086,
11,4.919685,1664409,1664409,1.32,4.01339,
12,4.92152,1664409,1664409,1.31,6.043082,
13,4.914327,1664409,1664409,1.3,4.042386,
14,4.921591,1664409,1664409,1.31,6.020083,
15,4.915519,1664409,1664409,1.3,6.025086,
16,4.921741,1664420,1664420,1.29,4.039384,
17,4.91727,1664409,1664409,1.31,6.028084,
18,4.923068,1664725,1664702,1.35,4.100374,
19,4.912893,1664445,1664445,1.3,6.034084,
20,4.915938,1664409,1664409,1.29,6.046082,
21,4.909584,1664409,1664409,1.29,4.038384,
22,4.916837,1664409,1664409,1.3,6.043081,
23,4.914777,1664409,1664409,1.32,4.012391,
24,4.911404,1664409,1664409,1.3,6.031084,
25,4.90547,1664409,1664409,1.31,4.039386,
26,4.905342,1664412,1664412,1.29,4.017388,
27,4.901366,1664409,1664409,1.3,6.020085,
28,4.905891,1664409,1664409,1.29,4.051384,
29,4.90154,1664409,1664409,1.32,6.051081,
30,4.90753,1667448,1666878,1.33,4.18936,
31,4.901983,1664445,1664445,1.33,6.049079,
32,4.906097,1664409,1664409,1.31,6.034083,
33,4.902098,1664409,1664409,1.3,4.025388,
34,4.903553,1664409,1664409,1.32,6.045082,
35,4.902721,1664409,1664409,1.29,4.01139,
36,4.906909,1664409,1664409,1.3,6.029084,
37,4.90251,1664409,1664409,1.31,4.024388,
38,4.90531,1664409,1664409,1.31,4.038386,
39,4.900145,1664474,1664439,1.33,6.019084,
40,4.903023,1664409,1664409,1.3,4.021388,
41,4.902676,1664409,1664409,1.29,6.056079,
42,4.907717,1664725,1664702,1.33,4.104375,
43,4.902876,1664445,1664445,1.3,6.021085,
44,4.908289,1664409,1664409,1.31,6.039082,
45,4.904701,1664409,1664409,1.31,4.044386,
46,4.790515,1664409,1664409,1.3,6.024085,
47,4.800963,1664412,1664412,1.31,4.032386,
48,4.793566,1664409,1664409,1.3,6.030084,
49,4.806364,1664409,1664409,1.3,4.033384,
50,4.791437,1664409,1664409,1.31,6.043082,
51,4.804535,1664420,1664420,1.3,4.028388,
52,4.795503,1664409,1664409,1.29,6.023084,
53,4.803701,1664409,1664409,1.29,4.037386,
54,4.795439,1664752,1664729,1.33,6.138065,
55,4.807234,1664445,1664445,1.3,4.02039,
56,4.785374,1664409,1664409,1.31,4.023388,
57,4.798964,1664409,1664409,1.31,4.034385,
58,4.788128,1664409,1664409,1.29,4.029387,
59,4.809443,1664409,1664409,1.31,6.018085,
60,4.793875,1664409,1664409,1.29,4.030388