oracle表空间利用率

  select ff.s tablespace_name,
       ff.b total,
       (ff.b - fr.b) usage,
       fr.b free,
       round((ff.b - fr.b) / ff.b * 100) || '% ' usagep
  from (select tablespace_name s, sum(bytes) / 1024 / 1024 b
          from dba_data_files
         group by tablespace_name) ff,
       (select tablespace_name s, sum(bytes) / 1024 / 1024 b
          from dba_free_space
         group by tablespace_name) fr
 where ff.s = fr.s

    

 

    手动进行修改

   

alter tablespace users add datafile '/home/oracle/oradata/xxx/users02.dbf' size 10000M autoextend on  ;