Home » SQL & PL/SQL » SQL & PL/SQL » Trace all DML statements in a series of procedures
Trace all DML statements in a series of procedures [message #240072] Thu, 24 May 2007 01:29 Go to next message
cgk1983
Messages: 28
Registered: December 2005
Junior Member
Hi all,
I want to trace all DML statements in a series of Procedure calls
For suppose if my application calls Procedure A i want all DML statements to traced for that Procedure or Program unit name in series like "A" may call another 100 program units[function,packages,procedures] so i want DML trace info in all these program units.

Can u pls suggest any Oracle inbuilt utility is there.
Re: Trace all DML statements in a series of procedures [message #240075 is a reply to message #240072] Thu, 24 May 2007 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
suggest any Oracle inbuilt utility is there

There is none.
Activate the trace and analyze it.

Regards
Michel
Re: Trace all DML statements in a series of procedures [message #240233 is a reply to message #240075] Thu, 24 May 2007 07:42 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You might be able to use Dbms_Profiler
Re: Trace all DML statements in a series of procedures [message #240262 is a reply to message #240233] Thu, 24 May 2007 08:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I thought about it but dbms_profiler will not give you dynamic queries just static lines in the code.

Regards
Michel
Re: Trace all DML statements in a series of procedures [message #240292 is a reply to message #240262] Thu, 24 May 2007 09:53 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Ahh - there is that.

Tracing it is, then.
Previous Topic: How to rename a column in a view.
Next Topic: START WITH/CONNECT BY returns fewer rows in 10g than 9i
Goto Forum:
  


Current Time: Wed Dec 07 20:43:17 CST 2016

Total time taken to generate the page: 0.12278 seconds