find who/when sql statement was issued

Hi everyone,

Trying to find out how I can tell who and when a particular sql statement was issued. I realize 8i has the log miner. But I am running 8.0.5, how to accomplish this before 8i log miner?

Thanks in advance,
Kathy

You might be able to find it in V$SQL

Enable Auditing

both are right. Auditing will add perfomance overhead, check out in V$SQL DPT

Does V$SQL contain the full SQL text? cause the text field is only vc2(1000);

is so then check out v$sqltext table