Re: looking for blocking sql statement(s)

From: Rainer Klomps <Rainer.Klomps_at_arcor.de>
Date: Sun, 17 Feb 2008 15:58:32 +0100
Message-ID: <47b84b9c$0$23004$9b4e6d93@newsspool1.arcor-online.net>

"Andreas Mosmann" <mosmann_at_expires-29-02-2008.news-group.org> schrieb im Newsbeitrag news:1202818505.71_at_user.newsoffice.de...
> 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

This message: [ Message body ]
Next message: Robert Klemme: "Re: Help with Oracle constrant on two tables problem"
Previous message: Mark D Powell: "Re: Help with Oracle constrant on two tables problem"
In reply to: Andreas Mosmann: "looking for blocking sql statement(s)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message