Re: Interesting new V$ table in 11.2

From: Mladen Gogala <>
Date: Sun, 18 Sep 2011 22:24:33 +0000 (UTC)
Message-ID: <>

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".
>> --

> 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.

Received on Sun Sep 18 2011 - 17:24:33 CDT

Original text of this message