Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: is parallel hint kill the Server?
Havel Zhang 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
What is in the alert log?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri May 18 2007 - 10:43:58 CDT
![]() |
![]() |