07-22-2015 11:44:20:619 : *********** TestIO Utility version 1.4 **********************
07-22-2015 11:44:20:619 : Number of java threads	: 10
07-22-2015 11:44:20:728 : Database Type    : Oracle
07-22-2015 11:44:20:728 : Host Name        : localhost
07-22-2015 11:44:20:728 : Port             : 1521
07-22-2015 11:44:20:728 : ServiceName      : pttdb
07-22-2015 11:44:20:728 : User Name        : cmx_ors
07-22-2015 11:44:20:728 : Password         : ********** 
07-22-2015 11:44:20:728 : JDBC Url generated : jdbc:oracle:thin:@//localhost:1521/pttdb
07-22-2015 11:44:20:728 : Number of records: 60000000
07-22-2015 11:44:20:728 : *************************************************************
07-22-2015 11:44:20:728 : before 10 JDBC connections ....
07-22-2015 11:44:21:165 : after 10 JDBC connrections ....
07-22-2015 11:44:21:165 : JDBC driver version is: 11.2.0.2.0
07-22-2015 11:44:21:165 : Temp Table name - c_repos_test_420
07-22-2015 11:44:21:165 : DML operations are going to be run in multiple threads with thread count = 10
07-22-2015 11:44:21:165 : Start create table and indexes
07-22-2015 11:44:21:211 : CREATE TABLE c_repos_test_420 ( id int NOT NULL, create_date date, last_update_date date, column1 varchar(255), column2 varchar(255), column3 varchar(255), column4 varchar(255), column5 varchar(255), column6 varchar(255), column7 varchar(255), column8 varchar(255), column9 varchar(255), column10 varchar(255), column11 varchar(255), column12 varchar(255), column13 varchar(255), column14 varchar(255), column15 varchar(255), column16 varchar(255), column17 varchar(255), column18 varchar(255), column19 varchar(255), column20 varchar(255), column21 varchar(255), column22 varchar(255), PRIMARY KEY (id))
07-22-2015 11:44:21:227 : CREATE INDEX c_repos_test_420_index1 on c_repos_test_420(column1)
07-22-2015 11:44:21:227 : CREATE INDEX c_repos_test_420_index2 on c_repos_test_420(column2, column3, column4)
07-22-2015 11:44:21:227 : Done create table and indexes
07-22-2015 11:44:21:227 : Inserting rows in threads begin....
07-22-2015 11:44:21:227 : Start insert rows through thread number 0
07-22-2015 11:44:21:227 : Start insert rows through thread number 1
07-22-2015 11:44:21:227 : Start insert rows through thread number 2
07-22-2015 11:44:21:227 : Start insert rows through thread number 3
07-22-2015 11:44:21:227 : Start insert rows through thread number 4
07-22-2015 11:44:21:227 : Start insert rows through thread number 5
07-22-2015 11:44:21:227 : Start insert rows through thread number 6
07-22-2015 11:44:21:227 : Start insert rows through thread number 7
07-22-2015 11:44:21:227 : Start insert rows through thread number 8
07-22-2015 11:44:21:227 : Start insert rows through thread number 9
07-22-2015 12:40:14:781 : Done insert rows through thread number 4
07-22-2015 12:40:16:185 : Done insert rows through thread number 7
07-22-2015 12:40:27:822 : Done insert rows through thread number 1
07-22-2015 12:40:29:195 : Done insert rows through thread number 3
07-22-2015 12:40:34:234 : Done insert rows through thread number 5
07-22-2015 12:40:34:234 : Done insert rows through thread number 9
07-22-2015 12:40:35:341 : Done insert rows through thread number 6
07-22-2015 12:40:35:669 : Done insert rows through thread number 2
07-22-2015 12:40:38:025 : Done insert rows through thread number 8
07-22-2015 12:41:07:087 : Done insert rows through thread number 0
07-22-2015 12:41:07:087 : Inserting rows in threads end....
07-22-2015 12:41:07:087 : Updating rows in threads begin....
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 0
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 1
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 2
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 3
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 4
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 5
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 6
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 7
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 8
07-22-2015 12:41:07:087 : Start update rows for non-indexed columns through thread number 9
07-22-2015 12:41:21:580 : Done update rows through thread number 4
07-22-2015 12:41:21:580 : Done update rows through thread number 7
07-22-2015 12:41:21:580 : Done update rows through thread number 6
07-22-2015 12:41:21:611 : Done update rows through thread number 0
07-22-2015 12:41:21:611 : Done update rows through thread number 5
07-22-2015 12:41:21:627 : Done update rows through thread number 2
07-22-2015 12:41:21:642 : Done update rows through thread number 1
07-22-2015 12:41:21:642 : Done update rows through thread number 3
07-22-2015 12:41:21:642 : Done update rows through thread number 9
07-22-2015 12:41:21:658 : Done update rows through thread number 8
07-22-2015 12:41:21:658 : Updating rows in threads end....
07-22-2015 12:41:21:658 : Updating rows in threads begin....
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 0
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 1
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 2
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 3
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 4
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 5
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 6
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 7
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 8
07-22-2015 12:41:21:673 : Start update rows for indexed columns through thread number 9
07-22-2015 12:41:38:724 : Done update rows through thread number 3
07-22-2015 12:41:38:771 : Done update rows through thread number 5
07-22-2015 12:41:38:787 : Done update rows through thread number 8
07-22-2015 12:41:38:787 : Done update rows through thread number 1
07-22-2015 12:41:38:802 : Done update rows through thread number 2
07-22-2015 12:41:38:802 : Done update rows through thread number 4
07-22-2015 12:41:38:818 : Done update rows through thread number 7
07-22-2015 12:41:38:818 : Done update rows through thread number 6
07-22-2015 12:41:38:818 : Done update rows through thread number 9
07-22-2015 12:41:38:834 : Done update rows through thread number 0
07-22-2015 12:41:38:834 : Updating rows in threads end....
07-22-2015 12:41:38:834 : Selecting rows in threads begin....
07-22-2015 12:41:38:834 : Start select rows through thread number 0
07-22-2015 12:41:38:834 : Start select rows through thread number 1
07-22-2015 12:41:38:834 : Start select rows through thread number 2
07-22-2015 12:41:38:834 : Start select rows through thread number 3
07-22-2015 12:41:38:834 : Start select rows through thread number 4
07-22-2015 12:41:38:834 : Start select rows through thread number 5
07-22-2015 12:41:38:834 : Start select rows through thread number 6
07-22-2015 12:41:38:834 : Start select rows through thread number 7
07-22-2015 12:41:38:834 : Start select rows through thread number 8
07-22-2015 12:41:38:834 : Start select rows through thread number 9
07-22-2015 12:41:50:034 : Done select rows through thread number 9
07-22-2015 12:41:50:081 : Done select rows through thread number 2
07-22-2015 12:41:50:097 : Done select rows through thread number 6
07-22-2015 12:41:50:097 : Done select rows through thread number 5
07-22-2015 12:41:50:097 : Done select rows through thread number 4
07-22-2015 12:41:50:112 : Done select rows through thread number 3
07-22-2015 12:41:50:128 : Done select rows through thread number 8
07-22-2015 12:41:50:128 : Done select rows through thread number 7
07-22-2015 12:41:50:128 : Done select rows through thread number 0
07-22-2015 12:41:50:144 : Done select rows through thread number 1
07-22-2015 12:41:50:144 : Selecting rows in threads end....
07-22-2015 12:41:50:144 : Deleting rows in threads begin....
07-22-2015 12:41:50:144 : Start delete rows through thread number 0
07-22-2015 12:41:50:144 : Start delete rows through thread number 1
07-22-2015 12:41:50:144 : Start delete rows through thread number 2
07-22-2015 12:41:50:144 : Start delete rows through thread number 3
07-22-2015 12:41:50:144 : Start delete rows through thread number 4
07-22-2015 12:41:50:144 : Start delete rows through thread number 5
07-22-2015 12:41:50:144 : Start delete rows through thread number 6
07-22-2015 12:41:50:144 : Start delete rows through thread number 7
07-22-2015 12:41:50:144 : Start delete rows through thread number 8
07-22-2015 12:41:50:144 : Start delete rows through thread number 9
07-22-2015 12:42:11:469 : Done delete rows through thread number 0
07-22-2015 12:42:11:484 : Done delete rows through thread number 2
07-22-2015 12:42:11:500 : Done delete rows through thread number 4
07-22-2015 12:42:11:500 : Done delete rows through thread number 1
07-22-2015 12:42:11:500 : Done delete rows through thread number 9
07-22-2015 12:42:11:500 : Done delete rows through thread number 7
07-22-2015 12:42:11:516 : Done delete rows through thread number 6
07-22-2015 12:42:11:547 : Done delete rows through thread number 3
07-22-2015 12:42:11:578 : Done delete rows through thread number 8
07-22-2015 12:42:11:609 : Done delete rows through thread number 5
07-22-2015 12:42:11:609 : Deleting rows in threads end....
07-22-2015 12:42:11:609 : Temp Table2 name - c_repos_test_5694
07-22-2015 12:42:11:609 : Start create table as select and indexes
07-22-2015 12:42:11:609 : CREATE TABLE c_repos_test_5694 as select * from c_repos_test_420
07-22-2015 12:44:11:948 : ALTER TABLE c_repos_test_5694 ADD CONSTRAINT c_repos_test_5694_id UNIQUE (id)
07-22-2015 12:46:17:232 : CREATE INDEX c_repos_test_5694_index1 on c_repos_test_5694(column1)
07-22-2015 12:48:00:176 : CREATE INDEX c_repos_test_5694_index2 on c_repos_test_5694(column2, column3, column4)
07-22-2015 12:50:14:586 : Done create table as select and indexes
07-22-2015 12:50:14:586 : Start drop table c_repos_test_420
07-22-2015 12:50:15:662 : Done drop table c_repos_test_420
07-22-2015 12:50:15:662 : Start drop table c_repos_test_5694
07-22-2015 12:50:15:912 : Done drop table c_repos_test_5694
07-22-2015 12:50:15:912 : ************************** Summary **************************
07-22-2015 12:50:15:912 : All DML operations ran in multiple threads with thread count = 10
07-22-2015 12:50:15:912 : All the timings are in hour:min:second:millisecond
07-22-2015 12:50:15:928 : Total distinct database interactions: 9
07-22-2015 12:50:15:928 : 0- operation type: CREATE, count:1
07-22-2015 12:50:15:928 : 1- operation type: INSERT, count:60000001
07-22-2015 12:50:15:928 : 2- operation type: UPDATE, count:200000
07-22-2015 12:50:15:928 : 3- operation type: UPDATE_INDEX, count:200000
07-22-2015 12:50:15:928 : 4- operation type: SELECT, count:200000
07-22-2015 12:50:15:928 : 5- operation type: DELETE, count:200000
07-22-2015 12:50:15:928 : 6- operation type: CTAS, count:1
07-22-2015 12:50:15:928 : 7- operation type: DROP, count:1
07-22-2015 12:50:15:928 : 8- operation type: DROP, count:1
07-22-2015 12:50:15:928 : Total time for the test: 1:5:54:747.0
07-22-2015 12:50:15:928 : Number of operations: 60800005
07-22-2015 12:50:15:928 : Average time for all operations: 0:0:0:0.0650451755719428
07-22-2015 12:50:15:928 : Average transactions/second for all operations: 15373
07-22-2015 12:50:15:928 : 
07-22-2015 12:50:15:928 : Number of create operations: 1
07-22-2015 12:50:15:928 : Total time for create operations: 0:0:0:62.0
07-22-2015 12:50:15:928 : Average time for all create operations: 0:0:0:62.0
07-22-2015 12:50:15:928 : Average transactions/second for all create operations: 16
07-22-2015 12:50:15:928 : 
07-22-2015 12:50:15:928 : Number of create table as select operations: 1
07-22-2015 12:50:15:928 : Total time for create table as select operations: 0:8:2:977.0
07-22-2015 12:50:15:928 : Average time for all create table as select operations: 0:8:2:977.0
07-22-2015 12:50:15:928 : Average transactions/second for all create table as select operations: 0
07-22-2015 12:50:15:928 : 
07-22-2015 12:50:15:928 : Number of drop operations: 2
07-22-2015 12:50:15:928 : Total time for drop operations: 0:0:1:326.0
07-22-2015 12:50:15:928 : Average time for all drop operations: 0:0:0:663.0
07-22-2015 12:50:15:928 : Average transactions/second for all drop operations: 1
07-22-2015 12:50:15:928 : 
07-22-2015 12:50:15:928 : Number of insert operations: 60000001
07-22-2015 12:50:15:928 : Total time for insert operations: 0:56:45:860.0
07-22-2015 12:50:15:928 : Average time for all insert operations: 0:0:0:0.05676433238726113
07-22-2015 12:50:15:928 : Average transactions/second for all insert operations: 17616
07-22-2015 12:50:15:928 : Total bytes of data inserted: 1158196632
07-22-2015 12:50:15:928 : Average bytes of data inserted/second (bytes/second): 340059
07-22-2015 12:50:15:928 : 
07-22-2015 12:50:15:928 : Number of update operations in non-indexed table: 200000
07-22-2015 12:50:15:928 : Total time for update operations in non-indexed table: 0:0:14:571.0
07-22-2015 12:50:15:928 : Average time for all update operations in non-indexed table: 0:0:0:0.072855
07-22-2015 12:50:15:928 : Average transactions/second for all update operations in non-indexed table: 13725
07-22-2015 12:50:15:928 : 
07-22-2015 12:50:15:928 : Number of update operations in indexed table: 200000
07-22-2015 12:50:15:928 : Total time for update operations in indexed table: 0:0:17:176.0
07-22-2015 12:50:15:928 : Average time for all update operations in indexed table: 0:0:0:0.08588
07-22-2015 12:50:15:928 : Average transactions/second for all update operations in indexed table: 11644
07-22-2015 12:50:15:928 : 
07-22-2015 12:50:15:928 : Number of select operations: 200000
07-22-2015 12:50:15:928 : Total time for select operations: 0:0:11:310.0
07-22-2015 12:50:15:928 : Average time for all select operations: 0:0:0:0.05655
07-22-2015 12:50:15:928 : Average transactions/second for all select operations: 17683
07-22-2015 12:50:15:928 : 
07-22-2015 12:50:15:928 : Number of delete operations: 200000
07-22-2015 12:50:15:928 : Total time for delete operations: 0:0:21:465.0
07-22-2015 12:50:15:928 : Average time for all delete operations: 0:0:0:0.107325
07-22-2015 12:50:15:928 : Average transactions/second for all delete operations: 9317
07-22-2015 12:50:15:928 : *************************************************************