Tracing Errors & warnings

Hello,

is there a way to trace all sql errors on an oracle database ? (without the grid)

I am debugging a progiciel that use oracle as db. I do not know what it is doing (SQL statement being executed) and the user being used to do that

Sometimes, i get this error : ORA 01031 insuficient privileges

My question:

is there something i can run to trace errors, and log the sql statement executed (just like MSSQL SQLProfiler would do)

Thanks

I have tried :

execute immediate 'alter session set events=''01031 trace name context forever, level 8'''; execute immediate 'alter session set max_dump_file_size = unlimited'; execute immediate 'alter session set timed_statistics = true';