Re: looking for blocking sql statement(s)
Date: Sun, 17 Feb 2008 15:58:32 +0100
"Andreas Mosmann" <mosmann_at_expires-29-02-2008.news-group.org> schrieb im
> 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
What about ?/rdbms/admin/utllockt ? Received on Sun Feb 17 2008 - 08:58:32 CST