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.
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.
V.matzianos@vereinigte-hagel.de
Am 19.11.2013 13:21 schrieb "Bert Scalzo" bounce-Bert_Scalzo@toadworld.com:
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.
The software does not have to be cheap or free. Which software tools are able to do this? What about Spotlight and Foglight?
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 …
Here was some info about Pine Cone I mentioned:
http://www.information-management.com/news/2316-1.html
Then acquired by Embarcadero …. Not sure what they sell that uses that technology …
monitor SQL queries != SQL Profiler!
