VIEW: SYS.EXU7STO

Source

View Text - Preformatted

SELECT user#,
                ts# * 4096 + file#, block#, iniexts, extsize, minexts, maxexts, 
		extpct, blocks, decode(lists, NULL, 1, 65535, 1, lists),
	      decode(groups, NULL, 1, 65535, 1, groups), extents
       FROM sys.seg$

View Text - HTML Formatted

SELECT USER#
, TS# * 4096 + FILE#
, BLOCK#
, INIEXTS
, EXTSIZE
, MINEXTS
, MAXEXTS
, EXTPCT
, BLOCKS
, DECODE(LISTS
, NULL
, 1
, 65535
, 1
, LISTS)
, DECODE(GROUPS
, NULL
, 1
, 65535
, 1
, GROUPS)
, EXTENTS
FROM SYS.SEG$