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_DBA_SEGS

Source

View Text - Preformatted


select NVL(u.name, 'SYS'), 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,
       f.file#, s.block#,
       NVL(s.blocks, 0) * ts.blocksize, NVL(s.blocks, 0), 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)),
       s.file#, bitand(s.cachehint, 3), bitand(s.cachehint, 12)/4,
       bitand(s.cachehint, 48)/16, NVL(s.spare1,0),
       decode(bitand(s.spare1, 1), 1,  s.hwmincr, o.dataobj#)
from sys.user$ u, sys.obj$ o, sys.ts$ ts, sys.sys_objects so, sys.seg$ s,
     sys.file$ f
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# = u.user# (+)
  and s.type# = so.segment_type_id
  and o.type# = so.object_type_id
  and s.ts# = f.ts#
  and s.file# = f.relfile#
union all
select NVL(u.name, 'SYS'), un.name, NULL,
       decode(s.type#, 1, 'ROLLBACK', 10, 'TYPE2 UNDO'), s.type#,
       NULL, ts.ts#, ts.name, ts.blocksize, f.file#, s.block#,
       NVL(s.blocks, 0) * ts.blocksize, NVL(s.blocks, 0), 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)),
       s.file#, bitand(s.cachehint, 3), bitand(s.cachehint, 12)/4,
       bitand(s.cachehint, 48)/16, NVL(s.spare1,0), un.us#
from sys.user$ u, sys.ts$ ts, sys.undo$ un, sys.seg$ s, sys.file$ f
where s.file# = un.file#
  and s.block# = un.block#
  and s.ts# = un.ts#
  and s.ts# = ts.ts#
  and s.user# = u.user# (+)
  and s.type# in (1, 10)
  and un.status$ != 1
  and un.ts# = f.ts#
  and un.file# = f.relfile#
union all
select NVL(u.name, 'SYS'), 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,
       f.file#, s.block#,
       NVL(s.blocks, 0) * ts.blocksize, NVL(s.blocks, 0), 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)),
       s.file#, bitand(s.cachehint, 3), bitand(s.cachehint, 12)/4,
       bitand(s.cachehint, 48)/16, NVL(s.spare1,0), s.hwmincr
from sys.user$ u, sys.ts$ ts, sys.seg$ s, sys.file$ f
where s.ts# = ts.ts#
  and s.user# = u.user# (+)
  and s.type# not in (1, 5, 6, 8, 10, 11)
  and s.ts# = f.ts#
  and s.file# = f.relfile#
union all
select NVL(u.name, 'SYS'), 'HEATMAP', NULL, 'SYSTEM STATISTICS', s.type#,
       NULL, ts.ts#, ts.name, ts.blocksize,
       f.file#, s.block#,
       NVL(s.blocks, 0) * ts.blocksize, NVL(s.blocks, 0), 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)),
       s.file#, bitand(s.cachehint, 3), bitand(s.cachehint, 12)/4,
       bitand(s.cachehint, 48)/16, NVL(s.spare1,0), s.hwmincr
from sys.user$ u, sys.ts$ ts, sys.seg$ s, sys.file$ f
where s.ts# = ts.ts#
  and s.user# = u.user# (+)
  and s.type# = 11
  and s.ts# = f.ts#
  and s.file# = f.relfile#

View Text - HTML Formatted

SELECT NVL(U.NAME
, 'SYS')
, 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
, F.FILE#
, S.BLOCK#
, NVL(S.BLOCKS
, 0) * TS.BLOCKSIZE
, NVL(S.BLOCKS
, 0)
, 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))
, S.FILE#
, BITAND(S.CACHEHINT
, 3)
, BITAND(S.CACHEHINT
, 12)/4
, BITAND(S.CACHEHINT
, 48)/16
, NVL(S.SPARE1
, 0)
, DECODE(BITAND(S.SPARE1
, 1)
, 1
, S.HWMINCR
, O.DATAOBJ#) FROM SYS.USER$ U
, SYS.OBJ$ O
, SYS.TS$ TS
, SYS.SYS_OBJECTS SO
, SYS.SEG$ S
, SYS.FILE$ F 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# = U.USER# (+)
AND S.TYPE# = SO.SEGMENT_TYPE_ID
AND O.TYPE# = SO.OBJECT_TYPE_ID
AND S.TS# = F.TS#
AND S.FILE# = F.RELFILE# UNION ALL SELECT NVL(U.NAME
, 'SYS')
, UN.NAME
, NULL
, DECODE(S.TYPE#
, 1
, 'ROLLBACK'
, 10
, 'TYPE2 UNDO')
, S.TYPE#
, NULL
, TS.TS#
, TS.NAME
, TS.BLOCKSIZE
, F.FILE#
, S.BLOCK#
, NVL(S.BLOCKS
, 0) * TS.BLOCKSIZE
, NVL(S.BLOCKS
, 0)
, 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))
, S.FILE#
, BITAND(S.CACHEHINT
, 3)
, BITAND(S.CACHEHINT
, 12)/4
, BITAND(S.CACHEHINT
, 48)/16
, NVL(S.SPARE1
, 0)
, UN.US# FROM SYS.USER$ U
, SYS.TS$ TS
, SYS.UNDO$ UN
, SYS.SEG$ S
, SYS.FILE$ F WHERE S.FILE# = UN.FILE#
AND S.BLOCK# = UN.BLOCK#
AND S.TS# = UN.TS#
AND S.TS# = TS.TS#
AND S.USER# = U.USER# (+)
AND S.TYPE# IN (1
, 10)
AND UN.STATUS$ != 1
AND UN.TS# = F.TS#
AND UN.FILE# = F.RELFILE# UNION ALL SELECT NVL(U.NAME
, 'SYS')
, 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
, F.FILE#
, S.BLOCK#
, NVL(S.BLOCKS
, 0) * TS.BLOCKSIZE
, NVL(S.BLOCKS
, 0)
, 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))
, S.FILE#
, BITAND(S.CACHEHINT
, 3)
, BITAND(S.CACHEHINT
, 12)/4
, BITAND(S.CACHEHINT
, 48)/16
, NVL(S.SPARE1
, 0)
, S.HWMINCR FROM SYS.USER$ U
, SYS.TS$ TS
, SYS.SEG$ S
, SYS.FILE$ F WHERE S.TS# = TS.TS#
AND S.USER# = U.USER# (+)
AND S.TYPE# NOT IN (1
, 5
, 6
, 8
, 10
, 11)
AND S.TS# = F.TS#
AND S.FILE# = F.RELFILE# UNION ALL SELECT NVL(U.NAME
, 'SYS')
, 'HEATMAP'
, NULL
, 'SYSTEM STATISTICS'
, S.TYPE#
, NULL
, TS.TS#
, TS.NAME
, TS.BLOCKSIZE
, F.FILE#
, S.BLOCK#
, NVL(S.BLOCKS
, 0) * TS.BLOCKSIZE
, NVL(S.BLOCKS
, 0)
, 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))
, S.FILE#
, BITAND(S.CACHEHINT
, 3)
, BITAND(S.CACHEHINT
, 12)/4
, BITAND(S.CACHEHINT
, 48)/16
, NVL(S.SPARE1
, 0)
, S.HWMINCR FROM SYS.USER$ U
, SYS.TS$ TS
, SYS.SEG$ S
, SYS.FILE$ F WHERE S.TS# = TS.TS#
AND S.USER# = U.USER# (+)
AND S.TYPE# = 11
AND S.TS# = F.TS#
AND S.FILE# = F.RELFILE#