Oracle表空间相关操作


1、关于表空间

//查看表空间
SQL> select tablespace_name from dba_data_files;

//查看所有表空间大小
SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;

//查看已使用表空间大小
SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;

发表评论