RE: If you replied... Optimizer Mode question with regard v$sqlar

2003-07-31 Thread Johnson, Michael
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

RE: If you replied... Optimizer Mode question with regard v$sqlar

2003-07-31 Thread John Kanagaraj
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