Re: Enterprise slow, Standard fast?

Arska wrote:

> One job, which we are using to test DB, get about 42s to run in EE.
> But if we set parallel_max_servers to 0, it takes 9s.
> Just like in SE, where parallel_max_servers is always 0
>
> So, the problem is: job is not tuned for parallel execution.
>
> Now we need to tune every job again, parallel execution in mind.
> Or deny parallel execution for these jobs. (How?)
> Correct?

Seems reasonable. How? The way one tunes any query. Start with DBMS_XPLAN and see what's happening.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)