> 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
>
Or the sql still in the shared pool is stored in the dynamic view
V$SQL. But beware that the recursive sql is also stored in this view.
Daniel
Received on Sat Jun 07 2003 - 10:32:59 CDT
