VIEW: SYS.EXU8TSQ

Source

View Text - Preformatted

SELECT  q.tsname, q.tsid, q.uname, q.userid,
                CEIL(q.maxblocks * (q.blocksize / (
                    SELECT  t$.blocksize
                    FROM    sys.ts$ t$
                    WHERE   t$.ts# = 0)))
        FROM    sys.exu9tsq q

View Text - HTML Formatted

SELECT Q.TSNAME
, Q.TSID
, Q.UNAME
, Q.USERID
, CEIL(Q.MAXBLOCKS * (Q.BLOCKSIZE / ( SELECT T$.BLOCKSIZE
FROM SYS.TS$ T$
WHERE T$.TS# = 0)))
FROM SYS.EXU9TSQ Q