Re: looking for blocking sql statement(s)

From: Andreas Mosmann <>
Date: Fri, 15 Feb 2008 13:41:46 +0100
Message-ID: <>

Mark D Powell schrieb am 13.02.2008 in

> You should be able to find a longer version of the SQL or the full sql
> by joining v$open_cursor to v$sqlarea (1000 bytes) or v$sqltext (multi-
> rows per SQL) or one of the other v$sql% views if it better suits your
> purpose.

thank you very much, sometimes it is difficult too find a tree in a wood ..

> HTH -- Mark D Powell --

Yes, it did
Andreas Mosmann

wenn email, dann AndreasMosmann <bei> web <punkt> de
Received on Fri Feb 15 2008 - 06:41:46 CST

Original text of this message