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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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/