07-22-2015 13:14:35:857 : *********** TestIO Utility version 1.4 **********************
07-22-2015 13:14:35:873 : Number of java threads	: 10
07-22-2015 13:14:36:356 : Database Type    : Oracle
07-22-2015 13:14:36:356 : Host Name        : torperf4
07-22-2015 13:14:36:356 : Port             : 1521
07-22-2015 13:14:36:356 : ServiceName      : pttdb
07-22-2015 13:14:36:356 : User Name        : cmx_ors
07-22-2015 13:14:36:356 : Password         : ********** 
07-22-2015 13:14:36:356 : JDBC Url generated : jdbc:oracle:thin:@//torperf4:1521/pttdb
07-22-2015 13:14:36:356 : Number of records: 60000000
07-22-2015 13:14:36:356 : *************************************************************
07-22-2015 13:14:36:356 : before 10 JDBC connections ....
07-22-2015 13:14:37:277 : after 10 JDBC connrections ....
07-22-2015 13:14:37:277 : JDBC driver version is: 11.2.0.2.0
07-22-2015 13:14:37:277 : Temp Table name - c_repos_test_2076
07-22-2015 13:14:37:277 : DML operations are going to be run in multiple threads with thread count = 10
07-22-2015 13:14:37:277 : Start create table and indexes
07-22-2015 13:14:37:370 : CREATE TABLE c_repos_test_2076 ( 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 13:14:37:386 : CREATE INDEX c_repos_test_2076_index1 on c_repos_test_2076(column1)
07-22-2015 13:14:37:386 : CREATE INDEX c_repos_test_2076_index2 on c_repos_test_2076(column2, column3, column4)
07-22-2015 13:14:37:386 : Done create table and indexes
07-22-2015 13:14:37:386 : Inserting rows in threads begin....
07-22-2015 13:14:37:386 : Start insert rows through thread number 0
07-22-2015 13:14:37:386 : Start insert rows through thread number 1
07-22-2015 13:14:37:386 : Start insert rows through thread number 2
07-22-2015 13:14:37:386 : Start insert rows through thread number 3
07-22-2015 13:14:37:402 : Start insert rows through thread number 4
07-22-2015 13:14:37:402 : Start insert rows through thread number 5
07-22-2015 13:14:37:402 : Start insert rows through thread number 6
07-22-2015 13:14:37:402 : Start insert rows through thread number 7
07-22-2015 13:14:37:402 : Start insert rows through thread number 8
07-22-2015 13:14:37:402 : Start insert rows through thread number 9
07-22-2015 14:11:50:094 : Done insert rows through thread number 7
07-22-2015 14:11:56:225 : Done insert rows through thread number 8
07-22-2015 14:12:00:265 : Done insert rows through thread number 2
07-22-2015 14:12:04:883 : Done insert rows through thread number 1
07-22-2015 14:12:11:154 : Done insert rows through thread number 4
07-22-2015 14:12:12:137 : Done insert rows through thread number 6
07-22-2015 14:12:19:516 : Done insert rows through thread number 5
07-22-2015 14:12:23:041 : Done insert rows through thread number 3
07-22-2015 14:12:37:596 : Done insert rows through thread number 9
07-22-2015 14:12:58:952 : Done insert rows through thread number 0
07-22-2015 14:12:58:952 : Inserting rows in threads end....
07-22-2015 14:12:58:952 : Updating rows in threads begin....
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 0
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 1
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 2
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 3
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 4
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 5
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 6
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 7
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 8
07-22-2015 14:12:58:952 : Start update rows for non-indexed columns through thread number 9
07-22-2015 14:13:14:443 : Done update rows through thread number 1
07-22-2015 14:13:14:506 : Done update rows through thread number 6
07-22-2015 14:13:14:506 : Done update rows through thread number 8
07-22-2015 14:13:14:521 : Done update rows through thread number 7
07-22-2015 14:13:14:552 : Done update rows through thread number 9
07-22-2015 14:13:14:552 : Done update rows through thread number 2
07-22-2015 14:13:14:552 : Done update rows through thread number 4
07-22-2015 14:13:14:599 : Done update rows through thread number 0
07-22-2015 14:13:14:864 : Done update rows through thread number 3
07-22-2015 14:13:14:896 : Done update rows through thread number 5
07-22-2015 14:13:14:896 : Updating rows in threads end....
07-22-2015 14:13:14:896 : Updating rows in threads begin....
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 0
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 1
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 2
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 3
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 4
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 5
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 6
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 7
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 8
07-22-2015 14:13:14:896 : Start update rows for indexed columns through thread number 9
07-22-2015 14:13:32:758 : Done update rows through thread number 7
07-22-2015 14:13:32:789 : Done update rows through thread number 2
07-22-2015 14:13:32:867 : Done update rows through thread number 8
07-22-2015 14:13:32:867 : Done update rows through thread number 9
07-22-2015 14:13:32:883 : Done update rows through thread number 3
07-22-2015 14:13:32:898 : Done update rows through thread number 1
07-22-2015 14:13:32:914 : Done update rows through thread number 4
07-22-2015 14:13:32:961 : Done update rows through thread number 6
07-22-2015 14:13:32:976 : Done update rows through thread number 0
07-22-2015 14:13:33:039 : Done update rows through thread number 5
07-22-2015 14:13:33:039 : Updating rows in threads end....
07-22-2015 14:13:33:039 : Selecting rows in threads begin....
07-22-2015 14:13:33:039 : Start select rows through thread number 0
07-22-2015 14:13:33:039 : Start select rows through thread number 1
07-22-2015 14:13:33:039 : Start select rows through thread number 2
07-22-2015 14:13:33:039 : Start select rows through thread number 3
07-22-2015 14:13:33:039 : Start select rows through thread number 4
07-22-2015 14:13:33:039 : Start select rows through thread number 5
07-22-2015 14:13:33:039 : Start select rows through thread number 6
07-22-2015 14:13:33:039 : Start select rows through thread number 7
07-22-2015 14:13:33:039 : Start select rows through thread number 8
07-22-2015 14:13:33:039 : Start select rows through thread number 9
07-22-2015 14:13:45:940 : Done select rows through thread number 8
07-22-2015 14:13:45:940 : Done select rows through thread number 3
07-22-2015 14:13:45:971 : Done select rows through thread number 7
07-22-2015 14:13:46:002 : Done select rows through thread number 2
07-22-2015 14:13:46:033 : Done select rows through thread number 9
07-22-2015 14:13:46:065 : Done select rows through thread number 6
07-22-2015 14:13:46:065 : Done select rows through thread number 4
07-22-2015 14:13:46:096 : Done select rows through thread number 0
07-22-2015 14:13:46:096 : Done select rows through thread number 1
07-22-2015 14:13:46:158 : Done select rows through thread number 5
07-22-2015 14:13:46:158 : Selecting rows in threads end....
07-22-2015 14:13:46:158 : Deleting rows in threads begin....
07-22-2015 14:13:46:158 : Start delete rows through thread number 0
07-22-2015 14:13:46:158 : Start delete rows through thread number 1
07-22-2015 14:13:46:158 : Start delete rows through thread number 2
07-22-2015 14:13:46:158 : Start delete rows through thread number 3
07-22-2015 14:13:46:158 : Start delete rows through thread number 4
07-22-2015 14:13:46:158 : Start delete rows through thread number 5
07-22-2015 14:13:46:158 : Start delete rows through thread number 6
07-22-2015 14:13:46:158 : Start delete rows through thread number 7
07-22-2015 14:13:46:158 : Start delete rows through thread number 8
07-22-2015 14:13:46:158 : Start delete rows through thread number 9
07-22-2015 14:14:06:813 : Done delete rows through thread number 9
07-22-2015 14:14:06:859 : Done delete rows through thread number 7
07-22-2015 14:14:06:875 : Done delete rows through thread number 2
07-22-2015 14:14:06:891 : Done delete rows through thread number 6
07-22-2015 14:14:06:906 : Done delete rows through thread number 8
07-22-2015 14:14:06:906 : Done delete rows through thread number 5
07-22-2015 14:14:06:937 : Done delete rows through thread number 1
07-22-2015 14:14:06:953 : Done delete rows through thread number 0
07-22-2015 14:14:06:969 : Done delete rows through thread number 3
07-22-2015 14:14:06:969 : Done delete rows through thread number 4
07-22-2015 14:14:06:969 : Deleting rows in threads end....
07-22-2015 14:14:06:969 : Temp Table2 name - c_repos_test_8590
07-22-2015 14:14:06:969 : Start create table as select and indexes
07-22-2015 14:14:06:969 : CREATE TABLE c_repos_test_8590 as select * from c_repos_test_2076
07-22-2015 14:16:04:562 : ALTER TABLE c_repos_test_8590 ADD CONSTRAINT c_repos_test_8590_id UNIQUE (id)
07-22-2015 14:18:04:042 : CREATE INDEX c_repos_test_8590_index1 on c_repos_test_8590(column1)
07-22-2015 14:19:43:336 : CREATE INDEX c_repos_test_8590_index2 on c_repos_test_8590(column2, column3, column4)
07-22-2015 14:21:50:087 : Done create table as select and indexes
07-22-2015 14:21:50:087 : Start drop table c_repos_test_2076
07-22-2015 14:21:51:194 : Done drop table c_repos_test_2076
07-22-2015 14:21:51:194 : Start drop table c_repos_test_8590
07-22-2015 14:21:51:459 : Done drop table c_repos_test_8590
07-22-2015 14:21:51:459 : ************************** Summary **************************
07-22-2015 14:21:51:459 : All DML operations ran in multiple threads with thread count = 10
07-22-2015 14:21:51:459 : All the timings are in hour:min:second:millisecond
07-22-2015 14:21:51:459 : Total distinct database interactions: 9
07-22-2015 14:21:51:459 : 0- operation type: CREATE, count:1
07-22-2015 14:21:51:459 : 1- operation type: INSERT, count:60000001
07-22-2015 14:21:51:459 : 2- operation type: UPDATE, count:200000
07-22-2015 14:21:51:459 : 3- operation type: UPDATE_INDEX, count:200000
07-22-2015 14:21:51:459 : 4- operation type: SELECT, count:200000
07-22-2015 14:21:51:459 : 5- operation type: DELETE, count:200000
07-22-2015 14:21:51:459 : 6- operation type: CTAS, count:1
07-22-2015 14:21:51:459 : 7- operation type: DROP, count:1
07-22-2015 14:21:51:459 : 8- operation type: DROP, count:1
07-22-2015 14:21:51:491 : Total time for the test: 1:7:14:182.0
07-22-2015 14:21:51:491 : Number of operations: 60800005
07-22-2015 14:21:51:491 : Average time for all operations: 0:0:0:0.06635167217502697
07-22-2015 14:21:51:491 : Average transactions/second for all operations: 15071
07-22-2015 14:21:51:491 : 
07-22-2015 14:21:51:491 : Number of create operations: 1
07-22-2015 14:21:51:491 : Total time for create operations: 0:0:0:109.0
07-22-2015 14:21:51:491 : Average time for all create operations: 0:0:0:109.0
07-22-2015 14:21:51:491 : Average transactions/second for all create operations: 9
07-22-2015 14:21:51:491 : 
07-22-2015 14:21:51:491 : Number of create table as select operations: 1
07-22-2015 14:21:51:491 : Total time for create table as select operations: 0:7:43:118.0
07-22-2015 14:21:51:491 : Average time for all create table as select operations: 0:7:43:118.0
07-22-2015 14:21:51:491 : Average transactions/second for all create table as select operations: 0
07-22-2015 14:21:51:491 : 
07-22-2015 14:21:51:491 : Number of drop operations: 2
07-22-2015 14:21:51:491 : Total time for drop operations: 0:0:1:372.0
07-22-2015 14:21:51:491 : Average time for all drop operations: 0:0:0:686.0
07-22-2015 14:21:51:491 : Average transactions/second for all drop operations: 1
07-22-2015 14:21:51:491 : 
07-22-2015 14:21:51:491 : Number of insert operations: 60000001
07-22-2015 14:21:51:491 : Total time for insert operations: 0:58:21:566.0
07-22-2015 14:21:51:491 : Average time for all insert operations: 0:0:0:0.05835943236067613
07-22-2015 14:21:51:491 : Average transactions/second for all insert operations: 17135
07-22-2015 14:21:51:491 : Total bytes of data inserted: 1158196632
07-22-2015 14:21:51:491 : Average bytes of data inserted/second (bytes/second): 330765
07-22-2015 14:21:51:491 : 
07-22-2015 14:21:51:491 : Number of update operations in non-indexed table: 200000
07-22-2015 14:21:51:491 : Total time for update operations in non-indexed table: 0:0:15:944.0
07-22-2015 14:21:51:491 : Average time for all update operations in non-indexed table: 0:0:0:0.07972
07-22-2015 14:21:51:491 : Average transactions/second for all update operations in non-indexed table: 12543
07-22-2015 14:21:51:491 : 
07-22-2015 14:21:51:491 : Number of update operations in indexed table: 200000
07-22-2015 14:21:51:491 : Total time for update operations in indexed table: 0:0:18:143.0
07-22-2015 14:21:51:491 : Average time for all update operations in indexed table: 0:0:0:0.090715
07-22-2015 14:21:51:491 : Average transactions/second for all update operations in indexed table: 11023
07-22-2015 14:21:51:491 : 
07-22-2015 14:21:51:491 : Number of select operations: 200000
07-22-2015 14:21:51:491 : Total time for select operations: 0:0:13:119.0
07-22-2015 14:21:51:491 : Average time for all select operations: 0:0:0:0.065595
07-22-2015 14:21:51:491 : Average transactions/second for all select operations: 15245
07-22-2015 14:21:51:491 : 
07-22-2015 14:21:51:491 : Number of delete operations: 200000
07-22-2015 14:21:51:491 : Total time for delete operations: 0:0:20:811.0
07-22-2015 14:21:51:491 : Average time for all delete operations: 0:0:0:0.104055
07-22-2015 14:21:51:491 : Average transactions/second for all delete operations: 9610
07-22-2015 14:21:51:491 : *************************************************************