Oracle: X$KQFVT

select
   vi.kqfvinam     vi_nam,
   vt.kqftpsel     vt_select_stmt
from
   sys.x$kqfvi     vi                                  join
   sys.x$kqfvt     vt on vi.indx    = vt.indx    and
                         vi.inst_id = vt.inst_id and
                         vi.con_id  = vt.con_id
where
   lower(vt.kqftpsel) like '%x$%' 
-- vi.kqfvinam = 'V$SEGMENT_STATISTICS'
order by
   vi.kqfvinam
;