OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » trace DDL SQL (11gR2 Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: trace DDL SQL [message #568559 is a reply to message #568557]

Sun, 14 October 2012 01:52

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Re: trace DDL SQL [message #568563 is a reply to message #568560]

Sun, 14 October 2012 03:41

Michel Cadot
Messages: 68757
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

Report message to a moderator

Previous Topic:	Loading the CLOB data into table
Next Topic:	exp/imp tables from one tablespace to another

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 15 20:22:02 CDT 2025