问题:

I'd like to find a tool for Oracle that is similar to the SQL Server Profiler, but a cursory search hasn't yielded any good results. I just want to see, in real time, the queries that my application are making against the database.

Any suggestions?

回答1:

Quest software has some really good tools for Oracle. I think that both Foglight Performance Analysis for Oracle and Spotlight do what you're looking for. Not sure for Spotlight though.

回答2:

The v$ views in Oracle (which a lot of tools use) offer a wealth of information if you have access to them.

Here's an example on askTom to find the sql the current users are executing.

回答3:

AWR (automatic workload repository) is the most obvious answer. There's a description here.

But Oracle Enterprise Manager has better interface. Read about it here. You have to pay extra, but it gives you the interactivity you're looking for.

回答4:

PL/SQL Developer from Allround Automations is what we use here. More geared towards developers, it does have a session browser which will show locks, SQL statements, etc. Also a nice graphical explain plan window. It's cheaper than TOAD (at last look).