| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Hint for self-join connect by
That's good to know, John! The client told me "everything is slow"
under this patch, but so far I've only identified this CONNECT BY query
as something drastically different, in terms of performance. I found
that 9.2.0.8 with no security patch and with CPUApr2007 also yield this
poor performing plan, so I definitely need a workaround for this query.
So far initial results show a histogram on the START WITH column
(acct_id) gives me what I need. I tried indexes matching suggestions I
found on JL's web site (concerning how to tune access against
PLAN_TABLE), but while the plan picks them up, performance is the same.
Dave
David C. Herring, DBA | A c x i o m Delivery Center Organization
630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
From: John Darrah [mailto:darrah.john_at_gmail.com]
Sent: Tuesday, May 01, 2007 2:10 PM
To: Herring Dave - dherri
Cc: oracle-l
Subject: Re: Hint for self-join connect by
Hey Dave,
A friend of mine ran into this same problem after applying that cpu to 9.2.0.6. I'll try to get in touch with him to confirm but I believe he ended up setting _old_connect_by_enabled to true. this fixed his performance problem but caused the connect by to behave as it did in 8i which may not work for your query. Don't know if this will be of any help but I thought I'd pass it on.
John
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 01 2007 - 15:44:56 CDT
 |
 |