RE: Anybody more familiar with "_use_old_connect_by" than I am?

I'm curious to know if any of you with this performance problem has tried the "_optimizer_connect_by_cost_based" parameter. I needed to use it as a workaround for BUG 5089217 (thanks to answers of a recent post of mine) running 10.2.0.2.0 on AIX 5.3.

Also, the query that was having the issue did not exactly match the criteria for the bug, which makes me wonder if there are other happy side-effects of setting this parameter. Plus, this bug's supposed to be fixed in .3, which the latest rumor has it's release this month.

Rich

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Lord Sent: Monday, November 06, 2006 2:51 AM
To: mgogala_at_verizon.net
Cc: dreveewee_at_gmail.com; Carel-Jan Engel; Christian Antognini; oracle-l_at_freelists.org
Subject: Re: Anybody more familiar with "_use_old_connect_by" than I am?

On 06/11/06, Mladen Gogala <mgogala_at_verizon.net> wrote:
>
> Oh boy, is this a blast from the past or what?

We were bitten by this too. The performance of some hierarchical queries with FIRST_ROWS hints went through the floor when we moved to 9i. Strangely, when we removed the hint, the response time for getting the first few rows back improved, so we stuck with that and never got to using the parameter.

--
David Lord
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l