RE: anyway to trace a DDL statement?
- From: ryan_gaffuri@xxxxxxxxxxx
- To: cary.millsap@xxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 02 Nov 2007 18:05:45 +0000
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@xxxxxxxxxx>
> 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
Other related posts:
