Re: Q: How do I find the SQL-Statement that is causing a lock

From: Jonathan Lewis <Jonathan_at_jlcomp.demon.co.uk>
Date: 1996/01/17
Message-ID: <821915610snz_at_jlcomp.demon.co.uk>#1/1


In article <30fbfdd7.4604582_at_news.brookings.net>

           kasten_at_brookings.net "Chris Kasten" writes:

: > If I'm not mistaken - the sql statement you find using this method is not
: > guaranteed to be the locking statement - it is only the most recent sql
: > statement for the SID in question.
: >
:
: You are correct and I should have stated that. I like the odds tho...

Widen the net, go via v$open_cursor, to get the sql for all the current cursors for the session.

-- 
Jonathan Lewis
Received on Wed Jan 17 1996 - 00:00:00 CET

Original text of this message