SQL Sniffer for Oracle

[willianjhonnes]

Hi, everybody!

Wich components may I use to create a SQL Sniffer application to Oracle databases using ODAC components?

It will be a implementation to my applications, that works with a runtime class that controls my connection with database and create TOraStoredProc objects in runtime to execute my SPs in DB. I have tried to use a TOraSQLMonitor, but successless.

I want to create an application that can "sniff" any statement execution in my Oracle server in any session. Passing the SID to this application, it starts to sniff any statement executed in the server by this session, adding this to a log file or a TMemo component. It's an administrative tool to debug and/or analyse my PL/SQL codes, so as analyse the the usage of some resources of my applications. This can help me to improve/implemente better solutions to my customers, reducing the cost in my database.

Thank you.

---------------------------------------------------
Att.:
Willian Jhonnes L. dos Santos
Object/Free Pascal & Web/PHP Analist/Developer
[email protected]
---------------------------------------------------
Linux user number 449753
---------------------------------------------------
Powered by Slackware Linux 12.0
Kernel 2.6.21.5-custom
---------------------------------------------------

[jfudickar]

What about the DBMonitor
http://www.devart.com/dbmonitor/

Greetings
Jens

[willianjhonnes]

Hi Jens...

Thank you for answer.

The DBMonitor app is exactly what I want, but is an external application. I need to do the same thing in my application, with the same visual style of other applications I have developed, you know...

So, what I need is implement the same solution in my application, using the ODAC 6.25 components that I have license.

Thank you once again.

[jfudickar]

Use the SQLMonitor Component and the events of the component to show the data in your app manually.

Greetings
Jens