表空间

来源：互联网发布：淘宝的产品分类编辑：程序博客网时间：2024/05/22 00:09

1、查看表空间

select f.tablespace_name,a.total,u.used,f.free,

round((u.used/ a.total) * 100) "% used",

round((f.free/ a.total) * 100) "% Free"

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

from dba_data_files group by tablespace_name) a,

(select tablespace_name, round(sum(bytes/ (1024 * 1024))) used

from dba_extents group by tablespace_name) u,

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

from dba_free_space group by tablespace_name) f

WHERE a.tablespace_name = f.tablespace_name

and a.tablespace_name = u.tablespace_name;

2、增加表空间

给表空间 CRDDTL03_TS增加数据文件CRDDTL03_TS02.dbf，并且允许数据文件自动增长的SQL：

ALTER TABLESPACE CRDDTL03_TS ADD DATAFILE '/oracle/oradata/data1/qsdb/CRDDTL03_TS02.dbf'SIZE 1024M

AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;

0 0