ryan, are you talking about in the raw trace or in the tkprof output? If tkprog output was sys=n specified on the tkprof run? -- Mark D Powell -- -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Cary Millsap Sent: Thursday, November 01, 2007 11:13 AM To: ryan_gaffuri@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: anyway to trace a DDL statement? Ryan, That sounds pretty weird. All the recursive SQL should be in the trace file. Have you looked at the raw trace data to confirm that it's not there? Or are you by chance looking at your tkprof output (which might be hiding it from you)? Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Hotsos Symposium 2008 / March 2-6 / Dallas Visit www.hotsos.com for curriculum and schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ryan_gaffuri@xxxxxxxxxxx Sent: Thursday, November 01, 2007 8:32 AM To: oracle-l@xxxxxxxxxxxxx Subject: anyway to trace a DDL statement? If I run a 10046 trace on a DDL statement, I do not get the recursive SQL that oracle runs underneath the DDL. Is there another form of trace that will show me what oracle is doing? -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l