VIEW: SYS.EXU81FIL

Source

View Text - Preformatted

SELECT  f.fname,
                NVL2(f.fsize, DECODE(f.fsize, -1, -1,
                    CEIL(f.fsize * ((
                    SELECT  t1$.blocksize
                    FROM    sys.ts$ t1$
                    WHERE   t1$.ts# = f.tsid) / (
                    SELECT  t0$.blocksize
                    FROM    sys.ts$ t0$
                    WHERE   t0$.ts# = 0)))), NULL),
                NVL2(f.maxextend, CEIL(f.maxextend * ((
                    SELECT  t1$.blocksize
                    FROM    sys.ts$ t1$
                    WHERE   t1$.ts# = f.tsid) / (
                    SELECT  t0$.blocksize
                    FROM    sys.ts$ t0$
                    WHERE   t0$.ts# = 0))), NULL),
                NVL2(f.inc, CEIL(f.inc * ((
                    SELECT  t1$.blocksize
                    FROM    sys.ts$ t1$
                    WHERE   t1$.ts# = f.tsid) / (
                    SELECT  t0$.blocksize
                    FROM    sys.ts$ t0$
                    WHERE t0$.ts# = 0))), NULL),
                f.tsid, f.bitmap
        FROM    sys.exu9fil f

View Text - HTML Formatted

SELECT F.FNAME
, NVL2(F.FSIZE
, DECODE(F.FSIZE
, -1
, -1
, CEIL(F.FSIZE * (( SELECT T1$.BLOCKSIZE
FROM SYS.TS$ T1$
WHERE T1$.TS# = F.TSID) / ( SELECT T0$.BLOCKSIZE
FROM SYS.TS$ T0$
WHERE T0$.TS# = 0))))
, NULL)
, NVL2(F.MAXEXTEND
, CEIL(F.MAXEXTEND * (( SELECT T1$.BLOCKSIZE
FROM SYS.TS$ T1$
WHERE T1$.TS# = F.TSID) / ( SELECT T0$.BLOCKSIZE
FROM SYS.TS$ T0$
WHERE T0$.TS# = 0)))
, NULL)
, NVL2(F.INC
, CEIL(F.INC * (( SELECT T1$.BLOCKSIZE
FROM SYS.TS$ T1$
WHERE T1$.TS# = F.TSID) / ( SELECT T0$.BLOCKSIZE
FROM SYS.TS$ T0$
WHERE T0$.TS# = 0)))
, NULL)
, F.TSID
, F.BITMAP
FROM SYS.EXU9FIL F