 | | | anyway to trace a DDL statement? | anyway to trace a DDL statement? 2007-11-02 - By ryan_gaffuri@(protected)
Back
bounced the DB. Ran it again and it worked.
I was looking at the raw trace file.
thanks guys.
-- ---- ------ Original message -- ---- ---- ---- ----
From: "Cary Millsap" <cary.millsap@(protected)>
> 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
|
|
|