Re: How to find the exact SQL locking others?
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: oracledbaquestions@xxxxxxxxx
- Date: Tue, 3 Jul 2012 15:08:07 -0400
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
