Subject: RE: anyway to trace a DDL statement? 2007-11-01 - By Powell, Mark D
Back
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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Cary Millsap
Sent: Thursday, November 01, 2007 11:13 AM
To: ryan_gaffuri@(protected); oracle-l@(protected)
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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of
ryan_gaffuri@(protected)
Sent: Thursday, November 01, 2007 8:32 AM
To: oracle-l@(protected)
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
|
|
