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
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