ok, got it :-) it was really the redo log, i have increase its size to 10 MB
and it works, here r the results:
--------------------Configuration: BatchTest - JDK version 1.3 <Default> -
<Default>--------------------
Oracle JDBC driver
batchsupport: true
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 4697 ms
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 4496 ms
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 4356 ms
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 4457 ms
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 4416 ms
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 4857 ms
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 4356 ms
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 4396 ms
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 4466 ms
1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
('0','0',0) : 11867 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 6679 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 5468 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 5408 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 12328 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 4577 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 4617 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 4947 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 4737 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 4907 ms
2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0) : 13179 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
3195 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
2864 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
2834 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
2804 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
2834 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
2814 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
2864 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
2814 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
2814 ms
4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?, ?):
10415 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 2013 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1953 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1823 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1792 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1742 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1743 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1743 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1742 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1723 ms
5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1703 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 110 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 110 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 190 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 100 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 90 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 100 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 90 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 100 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 90 ms
7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values (?, ?, ?): 100 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 1813 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 1803 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 9173 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 3135 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 1953 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 1973 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 2384 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 1853 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 1832 ms
8) single prepared jdbc batch with 333 stored proc calls: { call BT1
(?,?,?) }: 1892 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
841 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
360 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
340 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
371 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
361 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
360 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
341 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
361 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
330 ms
6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0); :
360 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4567 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4637 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4436 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4466 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4707 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4477 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4546 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4997 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4797 ms
3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
c2, c3) values ('0','0',0); : 4497 ms
Process completed.
"Steffen Ramlow" <s.ramlow_at_gmx.de> wrote in message
news:a17bh5$m5jr8$1_at_ID-54600.news.dfncis.de...
> i execute a stmt 1000 times in 10 loops against a oracle 8.0.5, but the
> execution time fluctuates dramatic
> i have no clue why
Received on Tue Jan 08 2002 - 12:26:26 CST