Re: SQL tracking on oracle

dbyy wrote:

> 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

Some reason you don't want to use the myriad possible tools already provided by Oracle and that you already paid for?

AUTOTRACE as IANAL_VISTA suggests
Log Miner
etc.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)