Re: How to find the exact SQL locking others?
From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 3 Jul 2012 15:08:07 -0400
Message-ID: <CAMVw97+TkwfVgYN9KUGdsuhATSNQ2qD6E7knAsC+fCY+a8wbRA_at_mail.gmail.com>
v$session.row_wait_obj# tells you the object you're waiting against most of the time (it also tells you file#,row# and block# so you can determine what specific row you're stuck against as well). It's not always have the information in which case looking at the current sql of a blocked session usually enough, also remember that both sessions will be holding TM locks against respective tables where ID1 is object_id of the table (that is, of course, unless somebody disabled table locks).
Date: Tue, 3 Jul 2012 15:08:07 -0400
Message-ID: <CAMVw97+TkwfVgYN9KUGdsuhATSNQ2qD6E7knAsC+fCY+a8wbRA_at_mail.gmail.com>
v$session.row_wait_obj# tells you the object you're waiting against most of the time (it also tells you file#,row# and block# so you can determine what specific row you're stuck against as well). It's not always have the information in which case looking at the current sql of a blocked session usually enough, also remember that both sessions will be holding TM locks against respective tables where ID1 is object_id of the table (that is, of course, unless somebody disabled table locks).
On Tue, Jul 3, 2012 at 2:31 PM, Dba DBA <oracledbaquestions_at_gmail.com> wrote:
>summary: figure out which table your blocked sessions sql is blocking on.
>
> so now you know which table is being blocked.
>
-- Alex Fatkulin, http://afatkulin.blogspot.com Enkitec, http://www.enkitec.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 03 2012 - 14:08:07 CDT