Re: SQL tracking on oracle

dbyy <noname_at_fooled.com> wrote in
news:Xns9644CA37F5CFBdbyyatcanadadotcomni_at_207.35.177.135:

> hi folks,
>
> 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
>
>
>

Thank you all for you advise. They helped me to solve the preblem.

Fred Received on Thu Apr 28 2005 - 12:18:18 CEST