Re: Interesting new V$ table in 11.2
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sun, 18 Sep 2011 22:24:33 +0000 (UTC)
Message-ID: <pan.2011.09.18.22.24.31_at_gmail.com>
On Sat, 17 Sep 2011 00:27:52 +0100, Jonathan Lewis wrote:
>
>
> If you want to see the object names, do an "explain plan". From memory
> v$session is based on x$ksuse (but added some bits in 10g and 11g)
> v$session_wait is based on x$ksusecst
>
> To show that they the two x$ are the same array with different bit
> exposed:
>
> a) Select addr from the two arrays - the addresses are identical b)
> join x$kqfta to x$kqfco (x$ tables and x$ columns) and you will see that
> x$ksuse has a big can in the column positions, which happens to match
> the column positions for x$ksusecst.
Date: Sun, 18 Sep 2011 22:24:33 +0000 (UTC)
Message-ID: <pan.2011.09.18.22.24.31_at_gmail.com>
On Sat, 17 Sep 2011 00:27:52 +0100, Jonathan Lewis wrote:
>> >> Mark's tip puts me on the right track, because it is possible to get >> the DDL and the tables for GV$SESSION_WAIT. My cunning plan has failed, >> which should not come as a big surprise to anyone who has watched >> "Black Adder". >> -- >> http://mgogala.byethost5.com
>
>
> If you want to see the object names, do an "explain plan". From memory
> v$session is based on x$ksuse (but added some bits in 10g and 11g)
> v$session_wait is based on x$ksusecst
>
> To show that they the two x$ are the same array with different bit
> exposed:
>
> a) Select addr from the two arrays - the addresses are identical b)
> join x$kqfta to x$kqfco (x$ tables and x$ columns) and you will see that
> x$ksuse has a big can in the column positions, which happens to match
> the column positions for x$ksusecst.
Thanks. Yes, I didn't think of that.
-- http://mgogala.byethost5.comReceived on Sun Sep 18 2011 - 17:24:33 CDT