Home » RDBMS Server » Server Utilities » trace DDL SQL (11gR2 Linux)
trace DDL SQL [message #568557] Sun, 14 October 2012 00:53 Go to next message
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 #568559 is a reply to message #568557] Sun, 14 October 2012 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does TKPROF return DDL?

Quote:
Or is this not the way to trace DDLs


1/ See your trace file
2/ What do you want in the end?

Regards
Michel

[Updated on: Sun, 14 October 2012 01:53]

Report message to a moderator

Re: trace DDL SQL [message #568560 is a reply to message #568559] Sun, 14 October 2012 02:25 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68625
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
Previous Topic: Loading the CLOB data into table
Next Topic: exp/imp tables from one tablespace to another
Goto Forum:
  


Current Time: Fri Mar 29 02:23:13 CDT 2024