Database Administration (MOSC)

MOSC Banner

Random Order Batch Execution Jobs

edited May 15, 2012 11:03AM in Database Administration (MOSC) 2 commentsAnswered
Hi,

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center