What query to use to check available space in datafiles and then tablespaces

What query to use to check available space in datafiles and then tablespaces

 

  

Could someone help me with a query that will enable me

To check the free/available space in the datafiles and then

Tablespaces again.



I have tried dba_free_space but I cant seem to find what I'm looking
for.



The other way could be to use dba_segments and minus it from
dba_tablespaces

But I'm sure there must be a quicker way



Thanks

Aldo Judeel


Oracle LazyDBA home page