Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
=================================================================
DBA_TABLESPACE_USAGE_METRICS describes tablespace usage metrics for all types of tablespaces, including permanent, temporary, and undo tablespaces.
Column
|
Datatype
|
NULL
|
Description
|
TABLESPACE_NAME | VARCHAR2(30) |
Tablespace name
| |
USED_SPACE | NUMBER |
Total space consumed by the tablespace
| |
TABLESPACE_SIZE | NUMBER |
Total size of the tablespace
| |
USED_PERCENT | NUMBER |
Percentage of used space, as a function of the maximum possible tablespace size
|
Note:
1. select * from DBA_TABLESPACE_USAGE_METRICS;
TABLESPACE_NAME
|
USED_SPACE
|
TABLESPACE_SIZE
|
USED_PERCENT
|
SDE
|
6204
|
16000
|
38.775
|
SYSAUX
|
303764
|
387072
|
78.4773892195767
|
SYSTEM
|
112016
|
256000
|
43.75625
|
TEMP
|
2048
|
2560000
|
0.08
|
UNDO
|
3093472
|
3584000
|
86.3133928571429
|
USERS
|
1231232
|
2609152
|
47.1889717425432
|
