Re: Parallel hint ignored only in subquery

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Thu, 24 Jul 2008 14:33:17 -0500 (CDT)
Message-ID: <25548.12.17.117.251.1216927997.squirrel@12.17.117.251>


I experiemented with the _optimizer_max_permutations parm at the session level with no luck. Then, I put a login trigger to:

alter session force parallel query parallel 3

...and the PQ works just fine. It would seem to be hint-related then?

Rich

> Hey all,
>
> In 10.1.0.5.0 on AIX, I'm attempting to merge an app's "lookup" query with
> it's driving SQL, i.e. app currently runs nasty query, then runs a SELECT
> for each row returned.
>
> The query has 12 tables joined, with 10 of the 11 joins being outer (LEFT
> OUTER JOIN in ANSI syntax, if that matters). From the explain plan, the
> driving table is obvious and I've successfully set a parallel hint on it's
> FTS for excellent runtime performance gains.

[snip]

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 24 2008 - 14:33:17 CDT

Original text of this message