SELECT /*+ ORDERED USE_NL(L), USE_NL(S), USE_NL(R) +*/
       s.inst_id, l.addr, l.ksqlkadr, s.ksusenum, r.ksqrsidt, r.ksqrsid1,
       r.k sqrsid2, l.ksqlkmod, l.ksqlkreq, l.ksqlkctim, l.ksqlklblk
  FROM x$ksqeq l, x$ksuse s, x$ksqrs r
 WHERE l.ksqlkses = s.addr
   AND BITAND (l.kssobflg, 1) != 0
   AND (l.ksqlkmod != 0 OR l.ksqlkreq != 0)
   AND l.ksqlkres = r.addr

SELECT x.inst_id, x.indx + 1, ksppinm, ksppity, ksppstvl, ksppstdf,
       DECODE (BITAND (ksppiflg / 256, 1), 1, 'TRUE', 'FALSE'),
       DECODE (BITAND (ksppiflg / 65536, 3),
               1, 'IMMEDIATE',
               2, 'DEFERRED',
               3, 'IMMEDIATE',
               'FALSE'
              ),
       DECODE (BITAND (ksppstvf, 7), 1, 'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE'),
       DECODE (BITAND (ksppstvf, 2), 2, 'TRUE', 'FALSE'), ksppdesc,
       ksppstcmnt
  FROM x$ksppi x, x$ksppcv y
 WHERE (x.indx = y.indx)
   AND ((TRANSLATE (ksppinm, '_', '#') NOT LIKE '#%') OR (ksppstdf = 'FALSE')
       )

SELECT inst_id, ksurlmnm, ksurlmcv, ksurlmmv,
       LPAD (DECODE (BITAND (ksurlmfg, 1),
                     0, TO_CHAR (ksurlmia),
                     'UNLIMITED'
                    ),
             10
            ),
       LPAD (DECODE (BITAND (ksurlmfg, 2),
                     0, TO_CHAR (ksurlmlv),
                     'UNLIMITED'
                    ),
             10
            )
  FROM x$ksurlmt

select inst_id,
       fts_tsn,
       fts_objn,
       fts_objd,
       fts_statnam,
       fts_statid,
       fts_staval
from x$ksolsfts
where fts_inte = 0