eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: SYS.DBA_TABLESPACES

Source

View Text - Preformatted


select ts.name, ts.blocksize, ts.blocksize * ts.dflinit,
          decode(bitand(ts.flags, 3), 1, to_number(NULL),
                 ts.blocksize * ts.dflincr),
          ts.dflminext,
          decode(ts.contents$, 1, to_number(NULL), ts.dflmaxext),
          decode(bitand(ts.flags, 4096), 4096, ts.affstrength, NULL),
          decode(bitand(ts.flags, 3), 1, to_number(NULL), ts.dflextpct),
          ts.blocksize * ts.dflminlen,
          decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE',
                 4, 'READ ONLY', 'UNDEFINED'),
          decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO',
                 'PERMANENT')), 1, 'TEMPORARY'),
          decode(bitand(ts.dflogging, 1), 0, 'NOLOGGING', 1, 'LOGGING'),
          decode(bitand(ts.dflogging, 2), 0, 'NO', 2, 'YES'),
          decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL'),
          decode(bitand(ts.flags, 3), 0, 'USER', 1, 'SYSTEM', 2, 'UNIFORM',
                 'UNDEFINED'),
          decode(ts.plugged, 0, 'NO', 'YES'),
          decode(bitand(ts.flags,32), 32,'AUTO', 'MANUAL'),
          decode(bitand(ts.flags,64), 64,'ENABLED', 'DISABLED'),
          decode(bitand(ts.flags,16), 16, (decode(bitand(ts.flags, 512), 512,
                 'GUARANTEE', 'NOGUARANTEE')), 'NOT APPLY'),
          decode(bitand(ts.flags,256), 256, 'YES', 'NO'),
          decode(tsattr.storattr, 1, 'STORAGE', 'HOST'),
          decode(bitand(ts.flags,16384), 16384, 'YES', 'NO'),
          decode(bitand(ts.flags,64), 0, null,
            (case when bitand(ts.flags,  65536) = 65536
                    then 'ADVANCED'
                  when bitand(ts.flags, (131072+262144)) = 131072
                    then concat('QUERY LOW',
                                decode(bitand(ts.flags, 4194304), 4194304,
                                       ' ROW LEVEL LOCKING', ''))
                  when bitand(ts.flags, (131072+262144)) = 262144
                    then concat('QUERY HIGH',
                                decode(bitand(ts.flags, 4194304), 4194304,
                                       ' ROW LEVEL LOCKING', ''))
                  when bitand(ts.flags, (131072+262144)) = (131072+262144)
                    then concat('ARCHIVE LOW',
                                decode(bitand(ts.flags, 4194304), 4194304,
                                       ' ROW LEVEL LOCKING', ''))
                  when bitand(ts.flags, 524288) = 524288
                    then concat('ARCHIVE HIGH',
                                decode(bitand(ts.flags, 4194304), 4194304,
                                       ' ROW LEVEL LOCKING', ''))
                  else 'BASIC' end)),
          --DEF_INMEMORY ktstsflg (ktt3.h)
          decode(bitand(ts.flags, 2203318222848),
                  4294967296,     'ENABLED',
                  2199023255552,  'DISABLED', 'DISABLED'),
          --DEF_INMEMORY_PRIORITY
          decode(bitand(ts.flags, 4294967296), 4294967296,
                 decode(bitand(ts.flags, 34359738368), 34359738368,
                        decode(bitand(ts.flags, 123145302310912),
                        17592186044416, 'LOW',
                        35184372088832, 'MEDIUM',
                        52776558133248, 'HIGH',
                        70368744177664, 'CRITICAL', 'NONE'),
                        'NONE'),
                 null),
          --DEF_INMEMORY_DISTRIBUTE
          decode(bitand(ts.flags, 4294967296), 4294967296,
                 decode(bitand(ts.flags, 8589934592), 8589934592,
                        decode(bitand(ts.flags, 206158430208),
                        68719476736,   'BY ROWID RANGE',
                        137438953472,  'BY PARTITION',
                        206158430208,  'BY SUBPARTITION',
                        0,             'AUTO'),
                        null),
                  null),
          --DEF_INMEMORY_COMPRESSION
          decode(bitand(ts.flags, 4294967296), 4294967296,
                 decode(bitand(ts.flags, 841813590016),
                              17179869184,  'NO MEMCOMPRESS',
                              274877906944, 'FOR DML',
                              292057776128, 'FOR QUERY LOW',
                              549755813888, 'FOR QUERY HIGH',
                              566935683072, 'FOR CAPACITY LOW',
                              824633720832, 'FOR CAPACITY HIGH', 'UNKNOWN'),
                 null),
          --DEF_INMEMORY_DUPLICATE
          decode(bitand(ts.flags, 4294967296), 4294967296,
                 decode(bitand(ts.flags, 13194139533312),
                         4398046511104, 'NO DUPLICATE',
                         8796093022208, 'DUPLICATE',
                         13194139533312, 'DUPLICATE ALL', null),
                 null)
from sys.ts$ ts, sys.x$kcfistsa tsattr
where ts.online$ != 3
and bitand(flags,2048) != 2048
and ts.ts# = tsattr.tsid

View Text - HTML Formatted

SELECT TS.NAME
, TS.BLOCKSIZE
, TS.BLOCKSIZE * TS.DFLINIT
, DECODE(BITAND(TS.FLAGS
, 3)
, 1
, TO_NUMBER(NULL)
, TS.BLOCKSIZE * TS.DFLINCR)
, TS.DFLMINEXT
, DECODE(TS.CONTENTS$
, 1
, TO_NUMBER(NULL)
, TS.DFLMAXEXT)
, DECODE(BITAND(TS.FLAGS
, 4096)
, 4096
, TS.AFFSTRENGTH
, NULL)
, DECODE(BITAND(TS.FLAGS
, 3)
, 1
, TO_NUMBER(NULL)
, TS.DFLEXTPCT)
, TS.BLOCKSIZE * TS.DFLMINLEN
, DECODE(TS.ONLINE$
, 1
, 'ONLINE'
, 2
, 'OFFLINE'
, 4
, 'READ ONLY'
, 'UNDEFINED')
, DECODE(TS.CONTENTS$
, 0
, (DECODE(BITAND(TS.FLAGS
, 16)
, 16
, 'UNDO'
, 'PERMANENT'))
, 1
, 'TEMPORARY')
, DECODE(BITAND(TS.DFLOGGING
, 1)
, 0
, 'NOLOGGING'
, 1
, 'LOGGING')
, DECODE(BITAND(TS.DFLOGGING
, 2)
, 0
, 'NO'
, 2
, 'YES')
, DECODE(TS.BITMAPPED
, 0
, 'DICTIONARY'
, 'LOCAL')
, DECODE(BITAND(TS.FLAGS
, 3)
, 0
, 'USER'
, 1
, 'SYSTEM'
, 2
, 'UNIFORM'
, 'UNDEFINED')
, DECODE(TS.PLUGGED
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(TS.FLAGS
, 32)
, 32
, 'AUTO'
, 'MANUAL')
, DECODE(BITAND(TS.FLAGS
, 64)
, 64
, 'ENABLED'
, 'DISABLED')
, DECODE(BITAND(TS.FLAGS
, 16)
, 16
, (DECODE(BITAND(TS.FLAGS
, 512)
, 512
, 'GUARANTEE'
, 'NOGUARANTEE'))
, 'NOT APPLY')
, DECODE(BITAND(TS.FLAGS
, 256)
, 256
, 'YES'
, 'NO')
, DECODE(TSATTR.STORATTR
, 1
, 'STORAGE'
, 'HOST')
, DECODE(BITAND(TS.FLAGS
, 16384)
, 16384
, 'YES'
, 'NO')
, DECODE(BITAND(TS.FLAGS
, 64)
, 0
, NULL
, (CASE WHEN BITAND(TS.FLAGS
, 65536) = 65536 THEN 'ADVANCED' WHEN BITAND(TS.FLAGS
, (131072+262144)) = 131072 THEN CONCAT('QUERY LOW'
, DECODE(BITAND(TS.FLAGS
, 4194304)
, 4194304
, ' ROW LEVEL LOCKING'
, '')) WHEN BITAND(TS.FLAGS
, (131072+262144)) = 262144 THEN CONCAT('QUERY HIGH'
, DECODE(BITAND(TS.FLAGS
, 4194304)
, 4194304
, ' ROW LEVEL LOCKING'
, '')) WHEN BITAND(TS.FLAGS
, (131072+262144)) = (131072+262144) THEN CONCAT('ARCHIVE LOW'
, DECODE(BITAND(TS.FLAGS
, 4194304)
, 4194304
, ' ROW LEVEL LOCKING'
, '')) WHEN BITAND(TS.FLAGS
, 524288) = 524288 THEN CONCAT('ARCHIVE HIGH'
, DECODE(BITAND(TS.FLAGS
, 4194304)
, 4194304
, ' ROW LEVEL LOCKING'
, '')) ELSE 'BASIC' END))
, --DEF_INMEMORY KTSTSFLG (KTT3.H) DECODE(BITAND(TS.FLAGS
, 2203318222848)
, 4294967296
, 'ENABLED'
, 2199023255552
, 'DISABLED'
, 'DISABLED')
, --DEF_INMEMORY_PRIORITY DECODE(BITAND(TS.FLAGS
, 4294967296)
, 4294967296
, DECODE(BITAND(TS.FLAGS
, 34359738368)
, 34359738368
, DECODE(BITAND(TS.FLAGS
, 123145302310912)
, 17592186044416
, 'LOW'
, 35184372088832
, 'MEDIUM'
, 52776558133248
, 'HIGH'
, 70368744177664
, 'CRITICAL'
, 'NONE')
, 'NONE')
, NULL)
, --DEF_INMEMORY_DISTRIBUTE DECODE(BITAND(TS.FLAGS
, 4294967296)
, 4294967296
, DECODE(BITAND(TS.FLAGS
, 8589934592)
, 8589934592
, DECODE(BITAND(TS.FLAGS
, 206158430208)
, 68719476736
, 'BY ROWID RANGE'
, 137438953472
, 'BY PARTITION'
, 206158430208
, 'BY SUBPARTITION'
, 0
, 'AUTO')
, NULL)
, NULL)
, --DEF_INMEMORY_COMPRESSION DECODE(BITAND(TS.FLAGS
, 4294967296)
, 4294967296
, DECODE(BITAND(TS.FLAGS
, 841813590016)
, 17179869184
, 'NO MEMCOMPRESS'
, 274877906944
, 'FOR DML'
, 292057776128
, 'FOR QUERY LOW'
, 549755813888
, 'FOR QUERY HIGH'
, 566935683072
, 'FOR CAPACITY LOW'
, 824633720832
, 'FOR CAPACITY HIGH'
, 'UNKNOWN')
, NULL)
, --DEF_INMEMORY_DUPLICATE DECODE(BITAND(TS.FLAGS
, 4294967296)
, 4294967296
, DECODE(BITAND(TS.FLAGS
, 13194139533312)
, 4398046511104
, 'NO DUPLICATE'
, 8796093022208
, 'DUPLICATE'
, 13194139533312
, 'DUPLICATE ALL'
, NULL)
, NULL) FROM SYS.TS$ TS
, SYS.X$KCFISTSA TSATTR WHERE TS.ONLINE$ != 3 AND BITAND(FLAGS
, 2048) != 2048 AND TS.TS# = TSATTR.TSID