Oracle Tablespace Notes

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