Re: fluctuating execution times

Hello Steffen,

I would say 10-20% is natural time deviation for any PC program:
thus, for example, all results from 4100 to 4900 (result #1) are the same. There is also very visible and often delay in 2200-2700 ms range in almost all results sets. I would guess this is garbage collection of JVM or similar process(s) of Oracle. Most probably it is Oracle (just a guess).

After all even 30-40% deviation is not critical. I found more interesting 5-10 times difference between #6 and #8.

If possible, can you describe (code fragment?) every set and just average time results?

Thanks for shearing data!

AlexV

"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
>
> i thought:
> allocating extends takes times - no it seems to be another thing, coz it
> does depends on the number of rows how offen the exec. time fluctuates
> lazy writer?
> other?
>
> damned!!! plz help :-)
>
>
> Oracle JDBC driver
> batchsupport: true
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 4997 ms
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 6449 ms
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 4106 ms
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 6249 ms
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 4106 ms
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 6319 ms
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 4206 ms
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 6800 ms
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 4427 ms
> 1) 1000 unprepared stmts: insert into BatchTest (c1, c2, c3) values
> ('0','0',0) : 6589 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 4476 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 6630 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 4497 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 6970 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 4527 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 6920 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 4587 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 6669 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 4616 ms
> 2) single unprepared jdbc batch with 1000 stmts: insert into BatchTest
(c1,
> c2, c3) values ('0','0',0) : 7571 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 2794 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 5468 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 2654 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 4787 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 2634 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 4907 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 2664 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 4907 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 2654 ms
> 4) 1000 prepared stmts: insert into BatchTest (c1, c2, c3) values (?, ?,
?):
> 5007 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1632 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1633 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 3936 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1592 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1593 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 3915 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1582 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1813 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 2764 ms
> 5) 333 prepared stored proc calls: { call BT1 (?,?,?) }: 1602 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 (?, ?, ?): 90 ms
> 7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values (?, ?, ?): 180 ms
> 7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values (?, ?, ?): 80 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 (?, ?, ?): 90 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 (?, ?, ?): 90 ms
> 7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values (?, ?, ?): 331 ms
> 7) single prepared jdbc batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values (?, ?, ?): 140 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 1862 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 1642 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 4106 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 1643 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 1652 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 3915 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 1903 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 1703 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 4176 ms
> 8) single prepared jdbc batch with 333 stored proc calls: { call BT1
> (?,?,?) }: 1693 ms
> 6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0);
:
> 921 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);
:
> 781 ms
> 6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0);
:
> 620 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);
:
> 340 ms
> 6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0);
:
> 952 ms
> 6) single unprepared sql batch with 333 stored proc calls: BT1('0','0',0);
:
> 491 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);
:
> 331 ms
> 3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values ('0','0',0); : 4677 ms
> 3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values ('0','0',0); : 4426 ms
> 3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values ('0','0',0); : 4396 ms
> 3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values ('0','0',0); : 4377 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); : 4707 ms
> 3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values ('0','0',0); : 4366 ms
> 3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values ('0','0',0); : 4427 ms
> 3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values ('0','0',0); : 4426 ms
> 3) single unprepared sql batch with 1000 stmts: insert into BatchTest (c1,
> c2, c3) values ('0','0',0); : 4747 ms
>
>
>
Received on Sat Jan 05 2002 - 12:12:10 CST