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
>
>
>

ALTER SESSION SET SQL_TRACE=TRUE;
-- works for "current session"

With some research/googling you can find out how to enable EVENT 10046 for the whole database & trace EVERY session & every SQL Received on Wed Apr 27 2005 - 04:38:23 CEST