RE: Stored outline not being used all the times...

  • From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
  • To: "Binh Pham" <binhpham15@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 8 Dec 2006 11:48:56 -0600

I've just filed an SR on it.  We'll see where it goes...
 
Rich

________________________________

From: Binh Pham [mailto:binhpham15@xxxxxxxxxxx] 
Sent: Friday, December 08, 2006 11:45 AM
To: Jesse, Rich; oracle-l@xxxxxxxxxxxxx
Subject: RE: Stored outline not being used all the times...



Jesse is correct.  I've seen multiple rows frequently with no mis-match.
A mystery. It is surprising that I've not seen any reply from the guru's
on this topic that I've posted now and before on stored outlines.  



        
________________________________

        From: "Jesse, Rich" <Rich.Jesse@xxxxxx>
        Reply-To: Rich.Jesse@xxxxxx
        To: <oracle-l@xxxxxxxxxxxxx>
        Subject: RE: Stored outline not being used all the times...
        Date: Thu, 7 Dec 2006 19:40:06 -0600
        
        
        Hi Fairle,
         
        The key word here is "should".  I agree, but if you look at my
query, you'll see that it's returning multiple rows with all "N"s for
the same address.  At least it is for me on 10.2.0.2.0.
         
        My 1 year old kept me up until 2:00 AM last night, so I could be
wrong.  I'll try and hammer away at it some more tomorrow.
         
        Thanks!
        Rich

________________________________

        From: fairlie rego [mailto:fairlie_r@xxxxxxxxx] 
        Sent: Thursday, December 07, 2006 5:48 PM
        To: binhpham15@xxxxxxxxxxx; Jesse, Rich
        Cc: oracle-l@xxxxxxxxxxxxx
        Subject: RE: Stored outline not being used all the times...
        
        
        The row with all 'N' should be the first child as mentioned here
<http://el-caro.blogspot.com/2006/11/diagnosing-unshared-sql-in-10g.html
> 
        All subsequent children should have some mismatch.
         
        -Fairlie
        

Other related posts: