Home » SQL & PL/SQL » SQL & PL/SQL » Tracing PL/SQL Code
Tracing PL/SQL Code [message #183656] Fri, 21 July 2006 15:14 Go to next message
basirana
Messages: 25
Registered: July 2006
Junior Member
How to trace a PL/SQL package?
How to trace Procedures?
How to trace SQL Statement?
I dont dont have access Linux. I am working with TOAD is there anyway we can create trace file in TOAD?
How to create log file in linux to trace the process?

Please give me steps...

Thanks
Rana
Re: Tracing PL/SQL Code [message #183664 is a reply to message #183656] Fri, 21 July 2006 16:51 Go to previous messageGo to next message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
ALTER SESSION SET SQL_TRACE=TRUE;
Re: Tracing PL/SQL Code [message #183679 is a reply to message #183656] Sat, 22 July 2006 00:20 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
basirana wrote on Fri, 21 July 2006 22:14

I am working with TOAD is there anyway we can create trace file in TOAD?
What does TOAD help say? About the trace files: those are located in the directory specified in the USER_DUMP_DEST database parameter. Once you have your tracefile, use tkprof to generate readable output.

MHE
Re: Tracing PL/SQL Code [message #183713 is a reply to message #183679] Sat, 22 July 2006 10:22 Go to previous messageGo to next message
basirana
Messages: 25
Registered: July 2006
Junior Member
I am working on Client mechine. I dont have access to all directories in the database server. we are accessing database mainly using oracle client and TOAD.because the package and procedures are accessed by other application we have access to linux env. were shell scripts will call the procedure inside the package.

The thing is there is anyway we can trace on the client side and check the trace. because we can run whole application to find whats going on.

Re: Tracing PL/SQL Code [message #183796 is a reply to message #183713] Sun, 23 July 2006 22:41 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi!
on the trace part, you could create a procedure to fetch the trace file from user_dump_dest, not sure of how you can use tkprof to convert the trace files, try installing a database on your machine like 10g XE, then run tkprof on those trace files, dont know if that would be much efficient =)
Previous Topic: Which query is better and Why ?
Next Topic: how to give privileges to synonyms
Goto Forum:
  


Current Time: Wed Dec 07 14:37:03 CST 2016

Total time taken to generate the page: 0.23483 seconds