RE: Tuning instance for batch processing

2003-02-13 Thread DENNIS WILLIAMS
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

Re: Tuning instance for batch processing

2003-02-13 Thread Mark Richard
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