oracle mos账号授权,oracle mos账号授权查看ORACLE各表空间使用情况

查看ORACLE各表空间使用情况

Sql代码

–各表空间分配情况

select tablespace_name, sum(bytes) / 1024 / 1024

from dba_data_files

group by tablespace_name;

&nbsoracle账号p;

–各表空间空闲情况

select tablespace_name, sum(bytes) / 1024 / 1024

from dba_free_space  -www.2cto.com-

group by tablespace_name;

–列表查看各表空间情况

select a.tablespace_name, total, free, total – free used

from (select tablespace_name, sum(bytes) / 1024 / 1024 total

from dba_data_files

group by tablespace_name) a,

(select tablespace_name, sum(bytes) / 1024 / 1024 free

from dba_free_space

group by tablespace_name) b

where a.tablespace_name = b.tablespace_name;

作者 guooo