On May 18, 1:30 am, Havel Zhang <havel.zh...@gmail.com> wrote:
> hi all:
>
> My oracle / OS version is 64bit Oracle 10g 10.2.0.2 and 64bit
> windows 2003 server with 8 CPUs. I had migrated my 9i to 10g, and i
> noticed that the query i specified hint /*+parallel(a)*/ will cause
> the Oracle use all 8 CPUs then the Server will down suddenly.
> When I specified /*+parallel(a,4)*/ then problem solved. And 9i
> haven't this problem.
>
> Any one come cross the same problem?
>
> Thank u in advanced.
>
> Havel

If you don't know how to proceed with deciding when to use parallel
query and when not to use it ... avoid it entirely.

Many people running oracle on systems with 8 cpu's actually do some
research to look at what might make sense for their systems.