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.

[Home] [Help]

VIEW: SYS.SYS_USER_SEGS

Source

View Text - Preformatted


select o.name,
       o.subname,
       so.object_type, s.type#,
       decode(bitand(s.spare1, 2097408), 2097152, 'SECUREFILE', 256, 'ASSM', 'MSSM'),
       ts.ts#, ts.name, ts.blocksize,
       s.file#, s.block#,
       s.blocks * ts.blocksize, s.blocks, s.extents,
       s.iniexts * ts.blocksize, s.extsize * ts.blocksize,
       s.minexts, s.maxexts,
       decode(bitand(s.spare1, 4194304), 4194304, bitmapranges, NULL),
       to_char(decode(bitand(s.spare1, 2097152), 2097152,
              decode(s.lists, 0, 'NONE', 1, 'AUTO', 2, 'MIN', 3, 'MAX',
                     4, 'DEFAULT', 'INVALID'), NULL)),
       decode(bitand(s.spare1, 2097152), 2097152, s.groups, NULL),
       decode(bitand(ts.flags, 3), 1, to_number(NULL),
                                      s.extpct),
       decode(bitand(ts.flags, 32), 32, to_number(NULL),
              decode(s.lists, 0, 1, s.lists)),
       decode(bitand(ts.flags, 32), 32, to_number(NULL),
              decode(s.groups, 0, 1, s.groups)),
       bitand(s.cachehint, 3), bitand(s.cachehint, 12)/4,
       bitand(s.cachehint, 48)/16, NVL(s.spare1, 0), s.hwmincr
from sys.obj$ o, sys.ts$ ts, sys.sys_objects so, sys.seg$ s
where s.file# = so.header_file
  and s.block# = so.header_block
  and s.ts# = so.ts_number
  and s.ts# = ts.ts#
  and o.obj# = so.object_id
  and o.owner# = userenv('SCHEMAID')
  and s.type# = so.segment_type_id
  and o.type# = so.object_type_id
union all
select un.name, NULL,
       decode(s.type#, 1, 'ROLLBACK', 10, 'TYPE2 UNDO'), s.type#,
       NULL, ts.ts#, ts.name, ts.blocksize,
       s.file#, s.block#,
       s.blocks * ts.blocksize, s.blocks, s.extents,
       s.iniexts * ts.blocksize, s.extsize * ts.blocksize, s.minexts,
       s.maxexts,
       decode(bitand(s.spare1, 4194304), 4194304, bitmapranges, NULL),
       NULL, NULL, s.extpct,
       decode(bitand(ts.flags, 32), 32, to_number(NULL),
              decode(s.lists, 0, 1, s.lists)),
       decode(bitand(ts.flags, 32), 32, to_number(NULL),
              decode(s.groups, 0, 1, s.groups)),
       bitand(s.cachehint, 3), bitand(s.cachehint, 12)/4,
       bitand(s.cachehint, 48)/16, NVL(s.spare1, 0), s.hwmincr
from sys.ts$ ts, sys.undo$ un, sys.seg$ s
where s.file# = un.file#
  and s.block# = un.block#
  and s.ts# = un.ts#
  and s.ts# = ts.ts#
  and s.user# = userenv('SCHEMAID')
  and s.type# in (1, 10)
  and un.status$ != 1
union all
select to_char(f.file#) || '.' || to_char(s.block#),
       NULL,
       decode(s.type#, 2, 'DEFERRED ROLLBACK', 3, 'TEMPORARY',
                      4, 'CACHE', 9, 'SPACE HEADER', 'UNDEFINED'), s.type#,
       NULL, ts.ts#, ts.name, ts.blocksize,
       s.file#, s.block#,
       s.blocks * ts.blocksize, s.blocks, s.extents,
       s.iniexts * ts.blocksize, s.extsize * ts.blocksize,
       s.minexts, s.maxexts,
       decode(bitand(s.spare1, 4194304), 4194304, bitmapranges, NULL),
       NULL, NULL, decode(bitand(ts.flags, 3), 1, to_number(NULL),
                                      s.extpct),
       decode(bitand(ts.flags, 32), 32, to_number(NULL),
              decode(s.lists, 0, 1, s.lists)),
       decode(bitand(ts.flags, 32), 32, to_number(NULL),
              decode(s.groups, 0, 1, s.groups)),
       bitand(s.cachehint, 3), bitand(s.cachehint, 12)/4,
       bitand(s.cachehint, 48)/16, NVL(s.spare1, 0), s.hwmincr
from sys.ts$ ts, sys.seg$ s, sys.file$ f
where s.ts# = ts.ts#
  and s.ts# = f.ts#
  and s.file# = f.relfile#
  and s.user# = userenv('SCHEMAID')
  and s.type# not in (1, 5, 6, 8, 10,11)
union all
select 'HEATMAP',
       NULL, 'SYSTEM STATISTICS', s.type#,
       NULL, ts.ts#, ts.name, ts.blocksize,
       s.file#, s.block#,
       s.blocks * ts.blocksize, s.blocks, s.extents,
       s.iniexts * ts.blocksize, s.extsize * ts.blocksize,
       s.minexts, s.maxexts,
       decode(bitand(s.spare1, 4194304), 4194304, bitmapranges, NULL),
       NULL, NULL, decode(bitand(ts.flags, 3), 1, to_number(NULL),
                                      s.extpct),
       decode(bitand(ts.flags, 32), 32, to_number(NULL),
              decode(s.lists, 0, 1, s.lists)),
       decode(bitand(ts.flags, 32), 32, to_number(NULL),
              decode(s.groups, 0, 1, s.groups)),
       bitand(s.cachehint, 3), bitand(s.cachehint, 12)/4,
       bitand(s.cachehint, 48)/16, NVL(s.spare1, 0), s.hwmincr
from sys.ts$ ts, sys.seg$ s, sys.file$ f
where s.ts# = ts.ts#
  and s.ts# = f.ts#
  and s.file# = f.relfile#
  and s.user# = userenv('SCHEMAID')
  and s.type# = 11

View Text - HTML Formatted

SELECT O.NAME
, O.SUBNAME
, SO.OBJECT_TYPE
, S.TYPE#
, DECODE(BITAND(S.SPARE1
, 2097408)
, 2097152
, 'SECUREFILE'
, 256
, 'ASSM'
, 'MSSM')
, TS.TS#
, TS.NAME
, TS.BLOCKSIZE
, S.FILE#
, S.BLOCK#
, S.BLOCKS * TS.BLOCKSIZE
, S.BLOCKS
, S.EXTENTS
, S.INIEXTS * TS.BLOCKSIZE
, S.EXTSIZE * TS.BLOCKSIZE
, S.MINEXTS
, S.MAXEXTS
, DECODE(BITAND(S.SPARE1
, 4194304)
, 4194304
, BITMAPRANGES
, NULL)
, TO_CHAR(DECODE(BITAND(S.SPARE1
, 2097152)
, 2097152
, DECODE(S.LISTS
, 0
, 'NONE'
, 1
, 'AUTO'
, 2
, 'MIN'
, 3
, 'MAX'
, 4
, 'DEFAULT'
, 'INVALID')
, NULL))
, DECODE(BITAND(S.SPARE1
, 2097152)
, 2097152
, S.GROUPS
, NULL)
, DECODE(BITAND(TS.FLAGS
, 3)
, 1
, TO_NUMBER(NULL)
, S.EXTPCT)
, DECODE(BITAND(TS.FLAGS
, 32)
, 32
, TO_NUMBER(NULL)
, DECODE(S.LISTS
, 0
, 1
, S.LISTS))
, DECODE(BITAND(TS.FLAGS
, 32)
, 32
, TO_NUMBER(NULL)
, DECODE(S.GROUPS
, 0
, 1
, S.GROUPS))
, BITAND(S.CACHEHINT
, 3)
, BITAND(S.CACHEHINT
, 12)/4
, BITAND(S.CACHEHINT
, 48)/16
, NVL(S.SPARE1
, 0)
, S.HWMINCR FROM SYS.OBJ$ O
, SYS.TS$ TS
, SYS.SYS_OBJECTS SO
, SYS.SEG$ S WHERE S.FILE# = SO.HEADER_FILE
AND S.BLOCK# = SO.HEADER_BLOCK
AND S.TS# = SO.TS_NUMBER
AND S.TS# = TS.TS#
AND O.OBJ# = SO.OBJECT_ID
AND O.OWNER# = USERENV('SCHEMAID')
AND S.TYPE# = SO.SEGMENT_TYPE_ID
AND O.TYPE# = SO.OBJECT_TYPE_ID UNION ALL SELECT UN.NAME
, NULL
, DECODE(S.TYPE#
, 1
, 'ROLLBACK'
, 10
, 'TYPE2 UNDO')
, S.TYPE#
, NULL
, TS.TS#
, TS.NAME
, TS.BLOCKSIZE
, S.FILE#
, S.BLOCK#
, S.BLOCKS * TS.BLOCKSIZE
, S.BLOCKS
, S.EXTENTS
, S.INIEXTS * TS.BLOCKSIZE
, S.EXTSIZE * TS.BLOCKSIZE
, S.MINEXTS
, S.MAXEXTS
, DECODE(BITAND(S.SPARE1
, 4194304)
, 4194304
, BITMAPRANGES
, NULL)
, NULL
, NULL
, S.EXTPCT
, DECODE(BITAND(TS.FLAGS
, 32)
, 32
, TO_NUMBER(NULL)
, DECODE(S.LISTS
, 0
, 1
, S.LISTS))
, DECODE(BITAND(TS.FLAGS
, 32)
, 32
, TO_NUMBER(NULL)
, DECODE(S.GROUPS
, 0
, 1
, S.GROUPS))
, BITAND(S.CACHEHINT
, 3)
, BITAND(S.CACHEHINT
, 12)/4
, BITAND(S.CACHEHINT
, 48)/16
, NVL(S.SPARE1
, 0)
, S.HWMINCR FROM SYS.TS$ TS
, SYS.UNDO$ UN
, SYS.SEG$ S WHERE S.FILE# = UN.FILE#
AND S.BLOCK# = UN.BLOCK#
AND S.TS# = UN.TS#
AND S.TS# = TS.TS#
AND S.USER# = USERENV('SCHEMAID')
AND S.TYPE# IN (1
, 10)
AND UN.STATUS$ != 1 UNION ALL SELECT TO_CHAR(F.FILE#) || '.' || TO_CHAR(S.BLOCK#)
, NULL
, DECODE(S.TYPE#
, 2
, 'DEFERRED ROLLBACK'
, 3
, 'TEMPORARY'
, 4
, 'CACHE'
, 9
, 'SPACE HEADER'
, 'UNDEFINED')
, S.TYPE#
, NULL
, TS.TS#
, TS.NAME
, TS.BLOCKSIZE
, S.FILE#
, S.BLOCK#
, S.BLOCKS * TS.BLOCKSIZE
, S.BLOCKS
, S.EXTENTS
, S.INIEXTS * TS.BLOCKSIZE
, S.EXTSIZE * TS.BLOCKSIZE
, S.MINEXTS
, S.MAXEXTS
, DECODE(BITAND(S.SPARE1
, 4194304)
, 4194304
, BITMAPRANGES
, NULL)
, NULL
, NULL
, DECODE(BITAND(TS.FLAGS
, 3)
, 1
, TO_NUMBER(NULL)
, S.EXTPCT)
, DECODE(BITAND(TS.FLAGS
, 32)
, 32
, TO_NUMBER(NULL)
, DECODE(S.LISTS
, 0
, 1
, S.LISTS))
, DECODE(BITAND(TS.FLAGS
, 32)
, 32
, TO_NUMBER(NULL)
, DECODE(S.GROUPS
, 0
, 1
, S.GROUPS))
, BITAND(S.CACHEHINT
, 3)
, BITAND(S.CACHEHINT
, 12)/4
, BITAND(S.CACHEHINT
, 48)/16
, NVL(S.SPARE1
, 0)
, S.HWMINCR FROM SYS.TS$ TS
, SYS.SEG$ S
, SYS.FILE$ F WHERE S.TS# = TS.TS#
AND S.TS# = F.TS#
AND S.FILE# = F.RELFILE#
AND S.USER# = USERENV('SCHEMAID')
AND S.TYPE# NOT IN (1
, 5
, 6
, 8
, 10
, 11) UNION ALL SELECT 'HEATMAP'
, NULL
, 'SYSTEM STATISTICS'
, S.TYPE#
, NULL
, TS.TS#
, TS.NAME
, TS.BLOCKSIZE
, S.FILE#
, S.BLOCK#
, S.BLOCKS * TS.BLOCKSIZE
, S.BLOCKS
, S.EXTENTS
, S.INIEXTS * TS.BLOCKSIZE
, S.EXTSIZE * TS.BLOCKSIZE
, S.MINEXTS
, S.MAXEXTS
, DECODE(BITAND(S.SPARE1
, 4194304)
, 4194304
, BITMAPRANGES
, NULL)
, NULL
, NULL
, DECODE(BITAND(TS.FLAGS
, 3)
, 1
, TO_NUMBER(NULL)
, S.EXTPCT)
, DECODE(BITAND(TS.FLAGS
, 32)
, 32
, TO_NUMBER(NULL)
, DECODE(S.LISTS
, 0
, 1
, S.LISTS))
, DECODE(BITAND(TS.FLAGS
, 32)
, 32
, TO_NUMBER(NULL)
, DECODE(S.GROUPS
, 0
, 1
, S.GROUPS))
, BITAND(S.CACHEHINT
, 3)
, BITAND(S.CACHEHINT
, 12)/4
, BITAND(S.CACHEHINT
, 48)/16
, NVL(S.SPARE1
, 0)
, S.HWMINCR FROM SYS.TS$ TS
, SYS.SEG$ S
, SYS.FILE$ F WHERE S.TS# = TS.TS#
AND S.TS# = F.TS#
AND S.FILE# = F.RELFILE#
AND S.USER# = USERENV('SCHEMAID')
AND S.TYPE# = 11