find who/when sql statement was issued

[kburrows]

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

[jdorlon]

You might be able to find it in V$SQL

[Kishore]

Enable Auditing

[aarganesh]

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

[sudip]

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

[aarganesh]

is so then check out v$sqltext table