Re: SQL plan different in dedicated vs. shared connection

Look at the bugs fixed for 9.2.0.6. Between wrong results (2243979) and performance of queries affected there are some perturbing situations.

Do you see sort activity in temp? I think Yong was on the right trail with memory, maybe those sort params. Since the manual workarea policy moves session information to the SGA with shared server, something is telling CBO to do more sorting. And if that something is one of those bugs, well, I don't know what to say. Try upping the sort parameters for the session and see if the plan changes. And remember, plans lie, if you are getting to this level of detail, use traces as Daniel Roy said.

jg

--
@home.com is bogus.
http://www.nj.com/business/ledger/index.ssf?/base/business-0/110827537541270.xml#continue