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博客

dba_ts_quotas