Re: looking for blocking sql statement(s)

Mark D Powell schrieb am 13.02.2008 in
<5a8fb550-638c-4256-abbe-cec2082c84b1_at_v17g2000hsa.googlegroups.com>:

> 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