Re: Interesting new V$ table in 11.2
From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Wed, 14 Sep 2011 10:58:19 -0700 (PDT)
Message-ID: <dd93acd3-4d55-49a0-8c5f-b8719b4963af_at_en1g2000vbb.googlegroups.com>
On Sep 14, 9:36 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> 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.com
Date: Wed, 14 Sep 2011 10:58:19 -0700 (PDT)
Message-ID: <dd93acd3-4d55-49a0-8c5f-b8719b4963af_at_en1g2000vbb.googlegroups.com>
On Sep 14, 9:36 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> 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.com
Take a look at v$wait_chains ... been around since 11.1 ( or earlier ).
You can use blocking_session and blocking_session_status from v $session when state = 'WAITING' then go after wait_chains ... Received on Wed Sep 14 2011 - 12:58:19 CDT