Re: How do I determine the SQL that was Run

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Sat, 07 Jun 2003 02:43:26 GMT
Message-ID: <ijcEa.42180$ca5.29503@nwrdny02.gnilink.net>

One way would be to turn sql_trace on for the server (or event 10046). Beware however that you might be looking forward to a large amount of logs.

If you are just interested in the DML being issued you can try log mining.

Search for sql_trace / log mining in Google or read the docs about it.

Anurag

"Time Vest Insurance" <reb_at_timevest.com> wrote in message news:l8zu1b2hcu1.fsf_at_timevest.com...
>
> We have an application that connects to our database. The queries are
> not directly available to us.
>
> Is it possible to turn something on in the Oracle Server that will allow
> us to see what queries are actually running from the application?
>
> Bob
>
Received on Fri Jun 06 2003 - 21:43:26 CDT