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

From: Jesse, Rich <Rich.Jesse_at_qg.com>
Date: Fri, 8 Dec 2006 11:48:56 -0600
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697A526E6@QTEX1.qg.com>

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

Rich

---

From: Binh Pham [mailto:binhpham15_at_hotmail.com] Sent: Friday, December 08, 2006 11:45 AM To: Jesse, Rich; oracle-l_at_freelists.org
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_at_qg.com>
	Reply-To: Rich.Jesse_at_qg.com
	To: <oracle-l_at_freelists.org>
	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_at_yahoo.com] 
	Sent: Thursday, December 07, 2006 5:48 PM
	To: binhpham15_at_hotmail.com; Jesse, Rich
	Cc: oracle-l_at_freelists.org
	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         

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 08 2006 - 11:48:56 CST