Hello,
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
I have a process that runs lots of similar jobs (for this example 8) and every time this process runs, it stores the time taken for each job in seconds. I am going to split this process into 4 chunks and would like to assign a 'chunk' number to each job so that each chunk will a quarter of these jobs
JOB NAME
| TIME IN SECONDS
| ASSIGNED CHUNK NUMBER
|
|---|
| JOB 1 | 80 | 1 |
| JOB 2 | 70 | 2 |
| JOB 3 | 60 | 3 |
| JOB 4 | 50 | 4 |
| JOB 5 | 40 | 4 |
| JOB 6 | 30 | 3 |
| JOB 7 | 20 | 2 |
| JOB 8 | 10 | 1 |
Is there anyway I can assign these chunk numbers dynamically using sql (assigned chunk number) so all the chunks estimated time will be pretty similar? so in the above example each 'chunk' will take 90 seconds?
Cheers,
Da