Oracle :: Tablespace Information

Or

select file_name, bytes, autoextensible, maxbytes, tablespace_name from dba _data_files;