DBA_TS_QUOTAS

Oracle 11gR1

DBA_TS_QUOTAS describes tablespace quotas for all users.

Related View

USER_TS_QUOTAS describes tablespace quotas for the current user. This view does not display the USERNAME column.

Column	Datatype	NULL	Description
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
DROPPED	VARCHAR2(3)		Whether the tablespace has been dropped

Note:

1.

select * from DBA_TS_QUOTAS;

TABLESPACE_NAME	USERNAME	BYTES	MAX_BYTES	BLOCKS	MAX_BLOCKS	DROPPED
TEMP	ORAMON	0	-1	0	-1	NO
TOOLS	KVIDAL	0	104857600	0	6400	NO
TOOLS	SPOTLIGHT	9437184	-1	576	-1	NO
USERS	DKYU	0	209715200	0	12800	NO
USERS	DLEE	7340032	209715200	448	12800	NO

Oracle data dictionary views