| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: anyway to trace a DDL statement?
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?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Cary Millsap
Sent: Thursday, November 01, 2007 11:13 AM
To: ryan_gaffuri_at_comcast.net; oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
ryan_gaffuri_at_comcast.net
Sent: Thursday, November 01, 2007 8:32 AM
To: oracle-l_at_freelists.org
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?
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 01 2007 - 14:01:28 CDT
 |
 |