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

[Message index]

		trace DDL SQL By: gkrishn on Sun, 14 October 2012 00:53
		Re: trace DDL SQL By: Michel Cadot on Sun, 14 October 2012 01:52
		Re: trace DDL SQL By: gkrishn on Sun, 14 October 2012 02:25
		Re: trace DDL SQL By: Michel Cadot on Sun, 14 October 2012 03:41

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: Fri May 03 23:57:30 CDT 2024