Home » Other » General » Oracle profiler
Oracle profiler [message #104509] Thu, 04 November 2004 22:12 Go to next message
praveen D
Messages: 1
Registered: November 2004
Junior Member
HI,

I would like to know is there any tool for Profiling oracle.
We can do this in SQL server.
can we do it in oracle 9i in any way.
i want to check where i am going wrong in my application.

thanks

Praveen

 
Re: Oracle profiler [message #104525 is a reply to message #104509] Mon, 15 November 2004 22:28 Go to previous messageGo to next message
sandeep
Messages: 110
Registered: October 2000
Senior Member
Try Statement Tracer for Oracle.
It is available free to download from
http://www.aboves.com/downloads
Re: Oracle profiler [message #322076 is a reply to message #104525] Thu, 22 May 2008 06:43 Go to previous messageGo to next message
xyzt
Messages: 27
Registered: April 2008
Junior Member
Hello,

I downloaded that tool and installed. It works if the query doesn't give any errors but if the query causes an error, the tool doesn't show the query...Anybody faced that problem?
thanks.
Re: Oracle profiler [message #414801 is a reply to message #322076] Thu, 23 July 2009 09:31 Go to previous messageGo to next message
easymatica
Messages: 5
Registered: July 2009
Junior Member
You can try FlexTracer from www.easy******.com/flextracer/index.htm, it is more advanced tool

[Updated on: Tue, 28 July 2009 08:37] by Moderator

Report message to a moderator

Re: Oracle profiler [message #414803 is a reply to message #414801] Thu, 23 July 2009 09:35 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
More advanced than a 5 years old tool, I hope so.

Regards
Michel
Re: Oracle profiler [message #414808 is a reply to message #414803] Thu, 23 July 2009 09:57 Go to previous message
ThomasG
Messages: 3099
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, there is always the built-in SQL Trace facility.

http://www.orafaq.com/wiki/SQL_Trace

That one DOES trace wrong statements.

=====================
PARSE ERROR #1:len=18 dep=0 uid=42 oct=3 lid=42 tim=13262491516806 err=942
SELECT 4 FROM daf
=====================
=====================
PARSE ERROR #1:len=25 dep=0 uid=42 oct=0 lid=42 tim=13262647503326 err=900
this is not a valid statement at all
=====================


The trace file can than be analysed with TKProf

http://www.orafaq.com/wiki/TKProf
Previous Topic: oRACLE 9i post installaion problem
Next Topic: Puzzle
Goto Forum:
  


Current Time: Mon Sep 01 20:08:08 CDT 2014

Total time taken to generate the page: 0.20314 seconds