Size DATAFILE NOTES

 

Size

DATAFILE NOTES:

File Name - Name of the datafile

Tablespace - Name of the tablespace

Datafile Size - Size of datafile (bytes)

Bytes Used - Amount of datafile used

Percent Used - Percent of datafile used

Bytes Free - Amount of datafile free

select  FILE_NAME,
 d.TABLESPACE_NAME,
 d.BYTES datafile_size,
 nvl(sum(e.BYTES),0) bytes_used,
 round(nvl(sum(e.BYTES),0) / (d.BYTES), 4) * 100 percent_used,
 d.BYTES - nvl(sum(e.BYTES),0) bytes_free
from  DBA_EXTENTS e,
 DBA_DATA_FILES d
where   d.FILE_ID = e.FILE_ID (+)
group   by FILE_NAME,d.TABLESPACE_NAME, d.FILE_ID, d.BYTES, STATUS
order   by d.TABLESPACE_NAME,d.FILE_ID