log select statements

[tosahil]

I want to create list of all SQL statements[including select] issued by one user. This is an application user and used to issue hell lot of statements.

I cant enable TRACE as it will be a big overload.

Is there any better way to do?

Thanks in advance.

Sahil Patel

[hrishy]

Hi

well it will be a big overload ..Hmm nope the answer is not at all.You enable tracing only for the duration of the problem when you suspect that the user is issuing those statements..

You should seriously check out sys.dbms_SYSTEM.set_sql_trace_in_sessio
only for that duration and turn it off

regards
Hrishy