CHECK TABLESPACE SIZE,PATH AND TABLESPACE_NAME IN ORACLE:


>> select file_name,status,tablespace_name,bytes/1024/1024 from dba_data_files;