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