trace DDL SQL [message #568557] |
Sun, 14 October 2012 00:53 |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
Hi ,
i wanted to trace DDLs that comes from application and did this .
EXECUTE DBMS_MONITOR.SESSION_TRACE_ENABLE(session_id => 1727, serial_num => 14319,waits => FALSE);
<waited till session completed all operation(ie,drop indexes)>
EXECUTE DBMS_MONITOR.SESSION_TRACE_DISABLE(session_id => 1727, serial_num => 14319);
Now i looked at tkprof output, I dont see any single DDL .
Am i missing something ? Or is this not the way to trace DDLs.
Please help.
|
|
|
|
Re: trace DDL SQL [message #568560 is a reply to message #568559] |
Sun, 14 October 2012 02:25 |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
1) i did a grep -i alter tracefile.trc
grep -i drop tracefile.trc
etc.. but dont see any DDL in trace file.
2)i want the list of DDLs executed from application to identify what they are doing through teh application.
|
|
|
Re: trace DDL SQL [message #568563 is a reply to message #568560] |
Sun, 14 October 2012 03:41 |
|
Michel Cadot
Messages: 68694 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Do NOT grep, read it.
DDL are, at SQL level, bunch of updates in the dictionary.
Regards
Michel
|
|
|