RE: query re-write SQL text

From: Joze Senegacnik <joze.senegacnik_at_dbprof.com>
Date: Tue, 22 Dec 2009 07:58:52 +0100
Message-ID: <8EDA253C997540478BA2A8948C45E301_at_dbprof.com>

Event 10053 trace will show you all possible transformations performed by CBO.   Jo¾e Senegaènik

Private researcher

Member of OakTable Network

Oracle
<http://apex.oracle.com/pls/otn/f?p=19297:4:2319630605653596::NO:4:P4_ID:122
0> ACE Co-author of the book "Expert Oracle
<http://www.apress.com/book/view/9781430226680> Practices"

Oracle related blog: http://joze-senegacnik.blogspot.com/

Blog about flying: http://jsenegacnik.blogspot.com/

Building Ovens, Baking and Cooking: http://senegacnik.blogspot.com

Mobile: +386 41 72 44 61  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of kyle Hailey
Sent: 22. december 2009 1:29
To: ORACLE-L
Subject: query re-write SQL text  

when Oracle re-writes a query, is there any way to get the new equivalent SQL Text?  

Thanks

Kyle  

http://db-optimizer.blogspot.com/

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

Received on Tue Dec 22 2009 - 00:58:52 CST