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 -> SQL plan different in dedicated vs. shared connection

SQL plan different in dedicated vs. shared connection

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 10 Feb 2005 19:27:02 GMT
Message-ID: <420bb4d2.685868887@localhost> 





Is this possible? I would think it would be possible with different
session settings (hash_area_size, sort_area_size, etc), but this (I
think) can only happen with work_area_policy set to auto, on this
system it was set to manual. Anything else I am missing? The
statistics on tables did not change between test.



Thanks.


.......


We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
remove NSPAM to email
Received on Thu Feb 10 2005 - 13:27:02 CST












Original text of this message













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