-
select *
-
from V$TABLESPACE
-
;
-
select *
-
from DBA_FREE_SPACE
-
where tablespace_name='USERS'
-
;
-
-
SELECT TABLESPACE_NAME "TABLESPACE", FILE_ID,
-
COUNT(*) "PIECES",
-
MAX(blocks) "MAXIMUM",
-
MIN(blocks) "MINIMUM",
-
AVG(blocks) "AVERAGE",
-
SUM(blocks) "TOTAL"
-
FROM DBA_FREE_SPACE
-
GROUP BY TABLESPACE_NAME, FILE_ID;
-
-
select
-
tablespace_name,
-
used_percent
-
from
-
dba_tablespace_usage_metrics
RJM Article Type
Quick Reference