查詢某資料表空間的使用方式資訊

Select t.tablespace_name name,d.allocated allocated_MB,u.used used_MB,f.free free_MB,t.status,d.cnt,contents,t.extent_management extman,t.segment_space_management segmant from dba_tablespaces t,(select sum(bytes)/1024/1024 allocated,count(file_id) cnt from dba_data_files where tablespace_name='&&tablespace_name')d,(select sum(bytes)/1024/1024 free from dba_free_spaceWhere tablespace_name='&tablespace_name')f,(select sum(bytes)/1024/1024  used from dba_segmentsWhere tablespace_name='&tablespace_name')uWhere t.tablespace_name='&tablespace_name';