Thanks!

Let me clarify something more here ...

In my database I can see 8 parallel processes being fired for the migration scripts. Normally this can be controlled by the DEFAULT parallel hint being reduced to a specified parallelism. Having a 4 CPU machine, I reduced this to 4, still I see 8 sessions being fired. I changed the Parallel_threads_per_cpu to 1.

Any ideas what might prevent the parallel hints being used to control the width of parallelism?

Regards