Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL plan different in dedicated vs. shared connection

Re: SQL plan different in dedicated vs. shared connection

From: <yong321_at_yahoo.com>
Date: 11 Feb 2005 06:58:31 -0800
Message-ID: <1108133911.882230.169710@z14g2000cwz.googlegroups.com> 





If this is reproducible, I'm guessing the free memory in shared pool
and (if configured) large pool is affecting CBO. Can you show us the
two execution plans, plus relevant initialization parameters?



Yong Huang
Received on Fri Feb 11 2005 - 08:58:31 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US