Interesting new V$ table in 11.2
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 14 Sep 2011 13:36:01 +0000 (UTC)
Message-ID: <pan.2011.09.14.13.36.00_at_gmail.com>
Database version 11.2 (I don't have any 11.1 at hand) has the table V$SESSION_BLOCKERS which lists blocking sessions on any instance. Before this, I've had to write "black magic" queries using GV$LOCK and ID1 and ID2 columns and GV$SESSION using V$ROW_OBJECT#, FILE#, BLOCK# and ROW#. This helps a lot. Good job, Oracle! Diagnosing lock contention has just become a lot easier, easy enough for a DBA 2.0.
Date: Wed, 14 Sep 2011 13:36:01 +0000 (UTC)
Message-ID: <pan.2011.09.14.13.36.00_at_gmail.com>
Database version 11.2 (I don't have any 11.1 at hand) has the table V$SESSION_BLOCKERS which lists blocking sessions on any instance. Before this, I've had to write "black magic" queries using GV$LOCK and ID1 and ID2 columns and GV$SESSION using V$ROW_OBJECT#, FILE#, BLOCK# and ROW#. This helps a lot. Good job, Oracle! Diagnosing lock contention has just become a lot easier, easy enough for a DBA 2.0.
-- http://mgogala.byethost5.comReceived on Wed Sep 14 2011 - 08:36:01 CDT