Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_TS_QUOTAS

Tablespace quotas for all users

Columns
   ___________________________
 
   USERNAME
      User with resource rights on the tablespace
   MAX_BLOCKS
      User's quota in ORACLE blocks.  NULL if no limit
   BLOCKS
      Number of ORACLE blocks charged to the user
   BYTES
      Number of bytes charged to the user
   TABLESPACE_NAME
      Tablespace name
   MAX_BYTES
      User's quota in bytes.  NULL if no limit

Related Commands:




Back to the Top

Simon Sheppard
SS64.com