Interesting new V$ table in 11.2

From: Mladen Gogala <>
Date: Wed, 14 Sep 2011 13:36:01 +0000 (UTC)
Message-ID: <>

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.
Received on Wed Sep 14 2011 - 08:36:01 CDT

Original text of this message