Message-Id: <10625.117432@fatcity.com> From: Chuck Hamilton Date: Wed, 20 Sep 2000 05:43:37 -0700 (PDT) Subject: RE: HASH_JOIN on RBO? --0-491705403-969453817=:16214 Content-Type: multipart/alternative; boundary="0-1918502651-969453817=:16214" --0-1918502651-969453817=:16214 Content-Type: text/plain; charset=us-ascii here are the attachments you wanted (why_cost.prf and why_cost.lst) Steve Adams wrote: Hi Chuck, In that case, either one of the other pieces of information that you've given us is incorrect, or this is a bug. Could you please try it as follows spool why_cost set long 1000 column text format a80 word select text from dba_views where view_name = 'PS_QVC_PERS_SRCH_VW'; alter session set events '10053 trace name context forever'; alter session set sql_trace = true; set autotrace traceonly explain SELECT --+ RULE ... spool off exit Please note the extra space before the hint comment to force a reparse. If you need to do it more than once, insert one more space each time, or flush the shared pool first. Please post the spool file and the trace file. --------------------------------- Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. --0-1918502651-969453817=:16214 Content-Type: text/html; charset=us-ascii

here are the attachments you wanted (why_cost.prf and why_cost.lst)

  Steve Adams <steve.adams@ixora.com.au> wrote:

Hi Chuck,

In that case, either one of the other pieces of information that you've given us
is incorrect, or this is a bug. Could you please try it as follows

spool why_cost
set long 1000
column text format a80 word
select text from dba_views where view_name = 'PS_QVC_PERS_SRCH_VW';
alter session set events '10053 trace name context forever';
alter session set sql_trace = true;
set autotrace traceonly explain
SELECT --+ RULE
...
spool off
exit

Please note the extra space before the hint comment to force a reparse. If you
need to do it more than once, insert one more space each time, or flush the
shared pool first. Please post the spool file and the trace file.


Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. --0-1918502651-969453817=:16214-- --0-491705403-969453817=:16214 Content-Type: text/plain; name="why_cost.txt" Content-Transfer-Encoding: 8bit Content-Description: why_cost.txt Content-Disposition: attachment; filename="why_cost.txt"