Statement tracer for oracle

Guido van Loon

Friday, October 27. 2006

Statement tracer for oracle

I love the Microsoft SQL Server profiler tool. This tool can be used for a lot of things but I like to use it to trace which stored procedures are called from my application and the parameters values that where used. Today I needed something similar for Oracle. Unfortunately this seems not as easy as it is with SQL Server. This is why I don't like Oracle everything is made so difficult...

There is a tool, however, that can trace the sql statements passed to the Oracle RDBMS. It's called OraTracer and can be found on the following website: http://www.aboves.com.

It is not as advanced as the SQL Server profiler tool but then again it's free! Before we get too excited I must point out OraTracer does not trace connections made from ASP.NET or BizTalk. I'm still trying to figure out why. Perhaps it has something to do with these processes not running under the normal user account...

Posted by Guido van Loon in Oracle Comment: (1) Trackbacks: (0)
Defined tags for this entry:
Related entries by tags:
Database modeling tool for Oracle
PL/SQL Developer substitution variables

Trackbacks
Trackback specific URI for this entry

No Trackbacks

Comments
Display comments as (Linear | Threaded)

#1 - Alfred Erz 2009-06-23 14:17 - (Reply)

I prefer a more advanced tool - FlexTracer. It is commercial, but it worth its money. Statement tracer for oracle has not been updated since 2006


Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA