looking for blocking sql statement(s)

Hi ng,

we got a software that often causes any locks/deadlocks. We look for the reason for this and I found V$LOCK and V$SQL. The problem is, that I can find out SQL of the waiting sessions, but I can not find out the SQL statement(s) that caused the problem. Do you have any idea?

Is it f.e. possible to log all sql statements used at the database (except of course the logging statement)?

Hope anyone can help

Andreas Mosmann

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de