DBA Data[Home] [Help]

VIEW: SYS.EXU8TNE

Source

View Text - Preformatted

SELECT  e.tsno, e.fileno, e.blockno,
                CEIL(e.length * ((
                    SELECT  t1$.blocksize
                    FROM    sys.ts$ t1$
                    WHERE   t1$.ts# = e.tsno) / (
                    SELECT  t0$.blocksize
                    FROM    sys.ts$ t0$
                    WHERE   t0$.ts# = 0)))
        FROM    sys.exu9tne e
View Text - HTML Formatted

SELECT E.TSNO
, E.FILENO
, E.BLOCKNO
, CEIL(E.LENGTH * (( SELECT T1$.BLOCKSIZE
FROM SYS.TS$ T1$
WHERE T1$.TS# = E.TSNO) / ( SELECT T0$.BLOCKSIZE
FROM SYS.TS$ T0$
WHERE T0$.TS# = 0)))
FROM SYS.EXU9TNE E