Mike,
This means that the same query was executed at least twice with a slightly
different executing environment which caused the optimizer to choose a
different execution path. See ML Note 1013747.102.
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
The opinions and advice expressed above are solely mine and not those of my
employer or client!
-Original Message-
Sent: Thursday, July 31, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L
All my e-mail was sys$hosed last night so could you please resend any and
all responses to this since last night.
Anybody run into a situation where you see optimizer_mode equal
multiple_children_present when the optimizer_mode is set to choose in the
init*.ora file ?
If so, did you follow up on it and try and determine why this was the case
and your results ? There is very little information on Metalink regarding
this issue.
Thank you for your time in advance.
Mike
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Kanagaraj
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).