SQL trace

[d27m11y]

I am trying to enable the SQL Trace on while I execute the procedure. Can someone guide me how to enable it

 

[Marco Kalter]

Go to the Session menu and select "SQL Trace" before executing the procedure. See also chapter 5.4 in the User's Guide.

 

[d27m11y]

I am kind of new to this. I did what you have suggested in the test window when I executed the procedure and I am trying to search the Trace file.. I am not able to find it.

Also, please let me know how I can run TKProf in Pl/Sql developer tool once I find the trace file.

 

[Theod]

Hi,

you'll find the tracefiles at the db-server.

select value from v$parameter
where name = 'user_dump_dest'
;

Upload it to your local-drive and use the shell-command (cmd). Then you can start tkprof.

 

[d27m11y]

I enabled the SQL Trace while I executed the procedure.I tried to query "value" from v$parameter and I am getting NULL. Is there anythng that I need to setup for SQLTrace for enabling..

Please suggest!