| 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
What hoses me on that is this is really a CTAS - just slap "CREATE TABLE
dch_work_surr_mgmt_two PARALLEL NOLOGGING" in the front of this
statement.
I don't believe I can get the hash value of the base CTAS, as under 9i its really x number of statements, 1 per slave, each with its own hash value.
Sorry, guess I should have included that. :-)
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
> -----Original Message-----
> From: Allen, Brandon [mailto:Brandon.Allen_at_OneNeck.com]
> Sent: Monday, April 30, 2007 3:41 PM
> To: Herring Dave - dherri; oracle-l
> Subject: RE: Hint for self-join connect by
>
> Maybe try creating a stored outline for the query under the Apr CPU
and
> then try to use the same outline to force good execution with the Oct
> CPU, or just try to manually apply some/all of the hints from the
> outline.
>
> Regards,
> Brandon
>
>
> Privileged/Confidential Information may be contained in this message
or
> attachments hereto. Please advise immediately if you or your employer
do
> not consent to Internet email for messages of this kind. Opinions,
> conclusions and other information in this message that do not relate
to
> the official business of this company shall be understood as neither
given
> nor endorsed by it.
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 Mon Apr 30 2007 - 15:48:47 CDT
 |
 |