Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> is parallel hint kill the Server?

is parallel hint kill the Server?

From: Havel Zhang <havel.zhang_at_gmail.com>
Date: 17 May 2007 22:30:05 -0700
Message-ID: <1179466205.841321.215770@y80g2000hsf.googlegroups.com> 





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
Received on Fri May 18 2007 - 00:30:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US