Random Order Batch Execution Jobs
When the below statements are executed in Oracle 10, the execution order looks like this, batch no 1 executes first and so on:
TES_ID TES_DESC
------ --------------------------------------------------
1 BATCH NO: 1
2 BATCH NO: 2
3 BATCH NO: 3
4 BATCH NO: 4
5 BATCH NO: 5
6 BATCH NO: 6
7 BATCH NO: 7
8 BATCH NO: 8
9 BATCH NO: 9
10 BATCH NO: 10
However, when executed in Oracle 11, the execution order is random, for example:
TES_ID TES_DESC
------ --------------------------------------------------
1 BATCH NO: 3
2 BATCH NO: 7
3 BATCH NO: 4
4 BATCH NO: 8
5 BATCH NO: 1
6 BATCH NO: 5
7 BATCH NO: 9
8 BATCH NO: 2
9 BATCH NO: 6
10 BATCH NO: 10
Delete from log_test;
commit;
declare
i integer;
n number;
d date;
begin
d := sysdate;