RE: anyway to trace a DDL statement?

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Thu, 1 Nov 2007 09:13:28 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CFD4D686@WIN02.hotsos.com>

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 Received on Thu Nov 01 2007 - 10:13:28 CDT