Stefan - Batch jobs can vary quite a bit. There are report batch jobs that
just do queries. There are update batch jobs that query and write. It is
hard to have any rules of thumb that apply just to batch jobs.
Actually, batch jobs tend to be easier to tune because it is easier to
run repeated
Stefan,
Are you looking at tuning in terms of Oracle parameters or rewriting SQL?
I guess one of the first things to consider is: Will the server be doing
anything else at the same time? If the batch jobs are the only thing
running then you tuning should probably focus more on execution time