今天突然先查询一下数据库的数据量的大小,自己做了个脚本:
select sum(zongji)||'G' from (select tablespace_name,sum(bytes/1024/1024/1024) zongji from dba_segments group by tablespace_name);
今天突然先查询一下数据库的数据量的大小,自己做了个脚本:
select sum(zongji)||'G' from (select tablespace_name,sum(bytes/1024/1024/1024) zongji from dba_segments group by tablespace_name);