10g: select ... from ... start with ... connect by ... breaks parallelism?

From: Frank Bergemann <FBergemann_at_web.de>
Date: Wed, 23 Feb 2011 23:14:05 -0800 (PST)
Message-ID: <3f2291cf-a113-4d52-a3b0-41ff9dca0b15_at_a5g2000vbs.googlegroups.com>


i have a strange effect, since we added a select ... from ... start with ... connect by ... SQL stmt.
Oracle doesn't tune anymore for parallel pipelined functions - which it did before.
I.e. i only get a single worker session for the parallel pipelined functions.
When i disable the SQL stmt, then everything works fine. Really strange is, that - when the SQL stmt is having this effect w/o being invoked.
I.e. when it's in the code, then it is currently "dead code" (unused), because it depends on set-up/configuration, which currently doesn't allow to actually use it.
So the first question is, why such select ... from ... start with ... connect by ... SQL stmt breaks parallelism. The second question how it does w/o being actually used?

  • many thanks!

Frank Received on Thu Feb 24 2011 - 01:14:05 CST

Original text of this message