Re: Interesting new V$ table in 11.2
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 16 Sep 2011 06:56:50 -0700 (PDT)
Message-ID: <b42e3e0c-3ae0-44d8-9c93-c88029685ae2_at_17g2000yqv.googlegroups.com>
On Sep 14, 12:56 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 14 Sep 2011 09:13:47 -0700, dombrooks wrote:
> > See also the blocking_*, final_blocking_*, etc columns in the ever-
> > extending v$session.
>
> Yes, V$SESSION_WAIT and V$SESSION views have effectively been merged.
>
> --http://mgogala.byethost5.com
Date: Fri, 16 Sep 2011 06:56:50 -0700 (PDT)
Message-ID: <b42e3e0c-3ae0-44d8-9c93-c88029685ae2_at_17g2000yqv.googlegroups.com>
On Sep 14, 12:56 pm, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> On Wed, 14 Sep 2011 09:13:47 -0700, dombrooks wrote:
> > See also the blocking_*, final_blocking_*, etc columns in the ever-
> > extending v$session.
>
> Yes, V$SESSION_WAIT and V$SESSION views have effectively been merged.
>
> --http://mgogala.byethost5.com
Just for general information the v$session_wait veiw was always build on the same internal (x$) table as v$session. It is just that the information was not exposed by Oracle in the v$session view definition.
HTH -- Mark D Powell -- Received on Fri Sep 16 2011 - 08:56:50 CDT