dba_ts_quotas

describe tablespace quotas to all users

[@more@]

TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Tablespace name
USERNAME	VARCHAR2(30)	NOT NULL	User with resource rights on the tablespace
BYTES	NUMBER		Number of bytes charged to the user
MAX_BYTES	NUMBER		User's quota in bytes, or -1 if no limit
BLOCKS	NUMBER	NOT NULL	Number of Oracle blocks charged to the user
MAX_BLOCKS	NUMBER		User's quota in Oracle blocks, or -1 if no limit

其中bytes,blocks = select sum(bytes),sum(blocks) from dba_extents where owner='TEST' 从该数据目录视图中可以直接过去当前用户占用的表空间的实际大小 this is important for me

SUM(BYTES) SUM(BLOCKS)
524288 64

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/450962/viewspace-1027077/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/450962/viewspace-1027077/