VIEW: SYS.EXU8STO

Source

View Text - Preformatted

SELECT  s.ownerid, s.tsno, s.fileno, s.blockno,
                CEIL(s.iniext * (s.blocksize / (
                    SELECT  t$.blocksize
                    FROM    sys.ts$ t$
                    WHERE   t$.ts# = 0))),
                CEIL(s.sext * (s.blocksize / (
                    SELECT  t$.blocksize
                    FROM    sys.ts$ t$
                    WHERE   t$.ts# = 0))),
                s.minext, s.maxext, s.pctinc,
                CEIL(s.blocks * (s.blocksize / (
                    SELECT  t$.blocksize
                    FROM    sys.ts$ t$
                    WHERE   t$.ts# = 0))),
                s.lists, s.groups, s.extents, s.pcache, s.ts_type, s.tsname,
                s.isonline
        FROM    sys.exu9sto s

View Text - HTML Formatted

SELECT S.OWNERID
, S.TSNO
, S.FILENO
, S.BLOCKNO
, CEIL(S.INIEXT * (S.BLOCKSIZE / ( SELECT T$.BLOCKSIZE
FROM SYS.TS$ T$
WHERE T$.TS# = 0)))
, CEIL(S.SEXT * (S.BLOCKSIZE / ( SELECT T$.BLOCKSIZE
FROM SYS.TS$ T$
WHERE T$.TS# = 0)))
, S.MINEXT
, S.MAXEXT
, S.PCTINC
, CEIL(S.BLOCKS * (S.BLOCKSIZE / ( SELECT T$.BLOCKSIZE
FROM SYS.TS$ T$
WHERE T$.TS# = 0)))
, S.LISTS
, S.GROUPS
, S.EXTENTS
, S.PCACHE
, S.TS_TYPE
, S.TSNAME
, S.ISONLINE
FROM SYS.EXU9STO S