| 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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Do NOT grep, read it.
DDL are, at SQL level, bunch of updates in the dictionary.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
