Oracle 视图 DBA_TS_QUOTAS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_TS_QUOTAS显示针对每一个表空间的配额情况，包括：每个表空间的配额名称、用户名称、表空间名称、最大配额、已经使用的块数、可用块数、被忽略的块数、配额开始使用的时间、修改时间和更新时间。
使用DBA_TS_QUOTAS视图以查看表空间的配额信息：
SELECT quota_name, username, tablespace_name, max_blocks, blocks_used, available_blocks, ignored_blocks, start_time, modified_time, last_update FROM dba_ts_quotas;
官方英文解释
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 |
|
|
|
|
User with resource rights on the tablespace |
|
|
|
Number of bytes charged to the user |
|
|
|
|
User’s quota in bytes, or |
|
|
|
|
Number of Oracle blocks charged to the user |
|
|
|
|
User’s quota in Oracle blocks, or |
|
|
|
|
Whether the tablespace has been dropped |
See Also:
“USER_TS_QUOTAS”
