Re: looking for blocking sql statement(s)

From: Rainer Klomps <>
Date: Sun, 17 Feb 2008 15:58:32 +0100
Message-ID: <47b84b9c$0$23004$>

"Andreas Mosmann" <> schrieb im Newsbeitrag
> 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

Original text of this message