# Tool like "SQL Profiler" for Oracle

**URL:** <https://forums.toadworld.com/t/tool-like-sql-profiler-for-oracle/27719>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [November 19, 2013, 4:15am UTC](https://forums.toadworld.com/t/tool-like-sql-profiler-for-oracle/27719 "2013-11-19T04:15:51Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![matzvass](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@matzvass](https://forums.toadworld.com/u/matzvass)\
**Post date:** [November 19, 2013, 4:15am UTC](https://forums.toadworld.com/t/tool-like-sql-profiler-for-oracle/27719/1 "2013-11-19T04:15:51Z")

</div>

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/](http://www.datawizard.com/)) which is

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

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [November 19, 2013, 4:19am UTC](https://forums.toadworld.com/t/tool-like-sql-profiler-for-oracle/27719/2 "2013-11-19T04:19:43Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![matzvass](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@matzvass](https://forums.toadworld.com/u/matzvass)\
**Post date:** [November 19, 2013, 4:26am UTC](https://forums.toadworld.com/t/tool-like-sql-profiler-for-oracle/27719/3 "2013-11-19T04:26:25Z")

</div>

[V.matzianos@vereinigte-hagel.de](mailto:V.matzianos@vereinigte-hagel.de)

Am 19.11.2013 13:21 schrieb "Bert Scalzo" [bounce-Bert\_Scalzo@toadworld.com](mailto:bounce-Bert_Scalzo@toadworld.com):

> **[RE: Tool like "SQL Profiler" for Oracle](http://www.toadworld.com/products/toad-for-oracle/f/10/p/20796/42637.aspx#42637)**

> 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](http://www.toadworld.com/products/toad-for-oracle/f/10/t/20796.aspx?subscribe=false) on this subject.
> 
> Or [Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.
> 
> Toad for Oracle - Discussion Forum

> [Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/20796/42637.aspx?AbuseContentId=9a69d4c2-6cf1-4681-8616-93293ef79e38&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true) this post as spam/abuse.

> ![](https://global.discourse-cdn.com/quest/original/3X/5/0/50b30fd5f87c85fe5cba2635cb83316ca71250d7.gif)

---

<div class="post-metadata">

**Author:** ![matzvass](https://avatars.discourse-cdn.com/v4/letter/m/8e7dd6/32.png) [@matzvass](https://forums.toadworld.com/u/matzvass)\
**Post date:** [November 19, 2013, 4:45am UTC](https://forums.toadworld.com/t/tool-like-sql-profiler-for-oracle/27719/4 "2013-11-19T04:45:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [November 19, 2013, 4:51am UTC](https://forums.toadworld.com/t/tool-like-sql-profiler-for-oracle/27719/5 "2013-11-19T04:51:25Z")

</div>

As an example (and just one example – not the best or anything), check out  
[http://teleran.com](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 …

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [November 19, 2013, 5:01am UTC](https://forums.toadworld.com/t/tool-like-sql-profiler-for-oracle/27719/6 "2013-11-19T05:01:25Z")

</div>

Here was some info about Pine Cone I mentioned:

[http://www.information-management.com/news/2316-1.html](http://www.information-management.com/news/2316-1.html)

[http://www.ambeo.com/](http://www.ambeo.com/)

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

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [November 23, 2013, 9:47am UTC](https://forums.toadworld.com/t/tool-like-sql-profiler-for-oracle/27719/7 "2013-11-23T09:47:40Z")

</div>

monitor SQL queries != SQL Profiler!
