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?
+2
A:
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.
Pascal Thivent
2009-10-12 16:40:42
Thanks for the links. I'm downloading the demos now to see if they are what I'm looking for.
Kevin Babcock
2009-10-12 17:12:08
A:
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.
SeriousCallersOnly
2009-10-12 16:51:28
I do have access to them, but I don't want to have to manually run queries. I'd like some kind of visual tool that updates in real-time.
Kevin Babcock
2009-10-12 16:54:49
A:
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).
DCookie
2009-10-12 17:39:45
+1
A:
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.
Pop
2009-10-12 17:40:55
Thanks for the comments and links. I have a strong dislike for OEM, but that's probably because I'm fairly new to Oracle and not used to it. :)
Kevin Babcock
2009-10-12 22:54:48