VIEW: SYS.EXU9STO

Source

View Text - Preformatted

SELECT  s$.user#, s$.ts#, s$.file#, s$.block#, s$.iniexts, s$.extsize,
                s$.minexts, s$.maxexts, s$.extpct, s$.blocks,
                DECODE(BITAND(s$.spare1, 2097152), 2097152, NVL(s$.lists, 0),
                       DECODE(s$.lists, NULL, 1, 65535, 1, lists)),
                DECODE(BITAND(s$.spare1, 2097152), 2097152, NVL(s$.groups, 0),
                       DECODE(s$.groups, NULL, 1, 65535, 1, groups)),
                extents,
                DECODE(bitand(s$.cachehint, 3), 1, 'KEEP', 2, 'RECYCLE','DEFAULT'),
                DECODE(BITAND(s$.spare1, 1), 1,
                       DECODE(BITAND(ts$.flags, 3), 0, 0, 1, 1, 2, 2, -1),
                       0, -1, -1),
                ts$.name, DECODE(ts$.online$, 1, 1, 4, 1, 0),
                NVL(ts$.blocksize, 2048), BITAND (s$.spare1,2147483647),
                DECODE(BITAND(s$.spare1,4194304), 4194304, s$.bitmapranges, 0)
        FROM    sys.seg$ s$, sys.ts$ ts$
        WHERE   s$.ts# = ts$.ts#(+)

View Text - HTML Formatted

SELECT S$.USER#
, S$.TS#
, S$.FILE#
, S$.BLOCK#
, S$.INIEXTS
, S$.EXTSIZE
, S$.MINEXTS
, S$.MAXEXTS
, S$.EXTPCT
, S$.BLOCKS
, DECODE(BITAND(S$.SPARE1
, 2097152)
, 2097152
, NVL(S$.LISTS
, 0)
, DECODE(S$.LISTS
, NULL
, 1
, 65535
, 1
, LISTS))
, DECODE(BITAND(S$.SPARE1
, 2097152)
, 2097152
, NVL(S$.GROUPS
, 0)
, DECODE(S$.GROUPS
, NULL
, 1
, 65535
, 1
, GROUPS))
, EXTENTS
, DECODE(BITAND(S$.CACHEHINT
, 3)
, 1
, 'KEEP'
, 2
, 'RECYCLE'
, 'DEFAULT')
, DECODE(BITAND(S$.SPARE1
, 1)
, 1
, DECODE(BITAND(TS$.FLAGS
, 3)
, 0
, 0
, 1
, 1
, 2
, 2
, -1)
, 0
, -1
, -1)
, TS$.NAME
, DECODE(TS$.ONLINE$
, 1
, 1
, 4
, 1
, 0)
, NVL(TS$.BLOCKSIZE
, 2048)
, BITAND (S$.SPARE1
, 2147483647)
, DECODE(BITAND(S$.SPARE1
, 4194304)
, 4194304
, S$.BITMAPRANGES
, 0)
FROM SYS.SEG$ S$
, SYS.TS$ TS$
WHERE S$.TS# = TS$.TS#(+)