oracle怎么查看用户对应的表空间

SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size

FROM dba_tablespaces t, dba_data_files d

WHERE t.tablespace_name = d.tablespace_name

GROUP BY t.tablespace_name;

SELECT tablespace_name,file_id,file_name,

round(bytes / (1024 * 1024), 0) total_space

FROM dba_data_files ORDER BY tablespace_name;