SQL tracking on oracle

From: dbyy <noname_at_fooled.com>
Date: Tue, 26 Apr 2005 23:52:37 GMT
Message-ID: <Xns9644CA37F5CFBdbyyatcanadadotcomni_at_207.35.177.135>

[Quoted] hi folks,

[Quoted] [Quoted] I'm looking for a tool (or a solution in Oracle v 9.2) that can track all SQL statements of a session send to the rdbms.

I would like to track these for an analysis of an (Clipper) application that uses middleware (Mediator from OTC in Poland) to talk to Oracle.

The problem is that the application (written in Clipper) sends requests to th rdbms which are translated in Mediator to (unknown) SQL commands. It seems that we have to tune this clipper apps but I would like to know a little bit more about all SQL commands send to Oracle.

Q: Is there a tool known that tracks all SQL commands processed by Oracle or is even a feature in Oracle (performance monitor in OEM) available that shows me the SQL history of a session?

Any help or suggestion much appreciated. If you need more details, let me know and I can post them.

TIA
Fred Received on Wed Apr 27 2005 - 01:52:37 CEST

This message: [ Message body ]
Next message: IANAL_VISTA: "Re: SQL tracking on oracle"
Previous message: DA Morgan: "Re: Collapsing a column in layout dynamically in Oracle Reports 6"
Next in thread: IANAL_VISTA: "Re: SQL tracking on oracle"
Reply: IANAL_VISTA: "Re: SQL tracking on oracle"
Reply: DA Morgan: "Re: SQL tracking on oracle"
Reply: dbyy: "Re: SQL tracking on oracle"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message