ORACLE TABLESPACE QUERIES

desc dba_tablespaces

select * from dba_tablespace_usage_metrics

select * from dba_directories

select * from user_tablespaces

Select * from dba_data_files

Select * from dba_free_space