Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tkprof in client

user587133Nov 5 2008 — edited Nov 10 2008

This is what i do in my server to see the tkprof

-- setting user_dump_dest
alter system set user_dump_dest="/home/oracle/trace";

alter session set tracefile_identifier ="trace1";
ALTER SESSION SET SQL_TRACE = TRUE;

tkprof /home/oracle/trace/ora_16095_trace1.trc /home/oracle/trace/out.prf explain=scott/tiger SYS=NO

How can i do this same in my client .where i wont be having any idea about the server folders

need help on this or any articles

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2008

Added on Nov 5 2008

#general-database-discussions

7 comments

547 views