does oracle have any debug tool like profiler for sql server?

Posted on 2008-10-14
Last Modified: 2013-12-18
i want to debug my afterUpdateRowTrigger on oracle 10g. is there any debug tool like profiler for sql server 2000?

Question by:viola123
LVL 20

Assisted Solution

by:chaitu chaitu
chaitu chaitu earned 100 total points
ID: 22710610
check allround automation's PL/SQL developer or TOAD;
LVL 23

Accepted Solution

David earned 200 total points
ID: 22710618
I cannot speak to your MS tool, but would like to mention Oracle's free SQL Developer (  Otherwise Quest's TOAD for DBAs is my all-time-favorite Swiss Knife.
LVL 27

Assisted Solution

Tolomir earned 200 total points
ID: 22710863
I've got great results with dbvisualizer:

It can even connect to MS SQL Server.

This is the feature list


Author Comment

ID: 22726409
hi all,
thanks a lot. those tools are really good.


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Trying to get a Linked Server to Oracle DB working 21 76
Oracle collections 15 37
how to find out the count of records based on the subfolders paths 11 39
Fill Null values 5 36
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question