VIEW: SYS.DBA_TS_QUOTAS

Source

View Text - Preformatted

select ts.name, u.name, spc.blocks * ts.blocksize,
       decode(spc.maxblocks, -1, -1, spc.maxblocks * ts.blocksize),
       spc.blocks, spc.maxblocks, decode(ts.online$, 3, 'YES', 'NO')
from sys.ts$ ts, sys.tbs_space_usage spc, sys.user$ u
where spc.tsn  = ts.ts#
  and spc.user# = u.user#
  and spc.maxblocks != 0

View Text - HTML Formatted

SELECT TS.NAME
, U.NAME
, SPC.BLOCKS * TS.BLOCKSIZE
, DECODE(SPC.MAXBLOCKS
, -1
, -1
, SPC.MAXBLOCKS * TS.BLOCKSIZE)
, SPC.BLOCKS
, SPC.MAXBLOCKS
, DECODE(TS.ONLINE$
, 3
, 'YES'
, 'NO') FROM SYS.TS$ TS
, SYS.TBS_SPACE_USAGE SPC
, SYS.USER$ U WHERE SPC.TSN = TS.TS#
AND SPC.USER# = U.USER#
AND SPC.MAXBLOCKS != 0