Re: SQL plan different in dedicated vs. shared connection

Sorry. I don't know the answer. I did some test on my 9.2 database running on XP using much less complex tables. I can't get different execution plans. When I switch to shared server mode, I only explicitly change two parameters, shared_servers from 0 to 5 and dispatchers from not set to set to 'TCP,5'. I checked all parameters including undocumented ones between these two configurations. Only those related to these two are changed (but _load_without_compile changed case from "NONE" to "none"). I also checked 10053 event traces and can't find anything. Ignore my guess about free memory affecting CBO's decision.

Please try to reproduce again, and if you open a Tar, let us know if eventually you find the answer. Thanks.

Yong Huang
yong321ATyahoo.com Received on Fri Feb 11 2005 - 23:21:48 CST