Oracle数据字典说明

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