Toad World® Forums

Tool like "SQL Profiler" for Oracle


#1

Does anybody know how it is possible to monitor SQL queries in Oracle which are created by an external web application?

I do not need to do performance analysis. I just want to see the executed sql queries when I do something in the web application.

I worked before with SQL Server databases and the “SQL Profiler” tool from datawizard (http://www.datawizard.com/) which is

a really good monitoring tool, but I cannot find something similar for Oracle 11.


#2

There were zeveral enterprise grade Oracle network packet sniffers that would capture all SQL sent to the database server - and example used to be Pine Cone software (acquired by someone - I forget). These tools genrally cost six figures and were hard to setup - i.e. setup on server side with port re-mapping. I cannot think of any cheap, free or easy tools for this. Sorry.


#3

V.matzianos@vereinigte-hagel.de

Am 19.11.2013 13:21 schrieb “Bert Scalzo” bounce-Bert_Scalzo@toadworld.com:

RE: Tool like “SQL Profiler” for Oracle

Reply by Bert Scalzo
There were zeveral enterprise grade Oracle network packet sniffers that would capture all SQL sent to the database server - and example used to be Pine Cone software (acquired by someone - I forget). These tools genrally cost six figures and were hard to setup - i.e. setup on server side with port re-mapping. I cannot think of any cheap, free or easy tools for this. Sorry.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.


#4

The software does not have to be cheap or free. Which software tools are able to do this? What about Spotlight and Foglight?


#5

As an example (and just one example – not the best or anything), check out
http://teleran.com

These tools fall under category auditing/compliance tools – they monitor the database and record all sessions who connect and all SQL they send to the server.

We used to sell a tool in that category (forget its name) – but not anymore. The example above is just one example – there are many tools in this space. So do some searching …


#6

Here was some info about Pine Cone I mentioned:

http://www.information-management.com/news/2316-1.html

http://www.ambeo.com/

Then acquired by Embarcadero …. Not sure what they sell that uses that technology …


#7

monitor SQL queries != SQL Profiler!