| Oracle profiler [message #104509] |
Thu, 04 November 2004 22:12  |
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 #322076 is a reply to message #104525] |
Thu, 22 May 2008 06:43  |
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 #414808 is a reply to message #414803] |
Thu, 23 July 2009 09:57 |
ThomasG
Messages: 3212
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
