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 -> Re: is parallel hint kill the Server?

Re: is parallel hint kill the Server?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 18 May 2007 08:43:58 -0700
Message-ID: <1179503033.821585@bubbleator.drizzle.com>


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.org
Received on Fri May 18 2007 - 10:43:58 CDT

Original text of this message

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