oracle查看表空间剩余

SELECT tablespace_name 表空间,round( sum(blocks * 8192 / 1000000)/1024 ,3 ) 剩余空间G  FROM dba_free_space GROUP BY tablespace_name order by 剩余空间G;  --------------------------------------------- --解决临时表空间不足问题。  select username,default_tablespace,temporary_tablespace  from dba_users  where username='CTLTMP';      select file_name,tablespace_name  from dba_data_files  where tablespace_name='CTL';        create TEMPORARY tablespace TEMPBI TEMPFILE 'F:\oradata\TEMPBI01.dbf' size 30G REUSE;    ALTER USER stg TEMPORARY TABLESPACE TEMPBI;  ALTER USER mdm TEMPORARY TABLESPACE TEMPBI;  ALTER USER ctl TEMPORARY TABLESPACE TEMP;