Oracle表空间扩容
首先查看表空间所生的内存
select a.tablespace_name,
round (a.total_size) “total_size(MB)”,
round (a.total_size) - round (b.free_size,3)“used_size(MB)”,
round (b.free_size,3) “free_size(MB)”,
round (b.free_size/total_size * 100,2)|| ‘%’ free_rate from (select tablespace_name, sum(bytes)/1024/1024 total_size
from dba_Data_files
group by tablespace_name) a ,
(select tablespace_name ,sum (bytes)/1024/1024 free_size
from dba_free_space
group by tablespace_name) b where a.tablespace_name=b.tablespace_name(+);
然后查扩容目标表空间的路径
select b.file_id 文件ID,
b.tablespace_name 表空间,
b.file_name 物理文件名,
b.bytes 总字节数,
(b.bytes-sum(nvl(a.bytes,0))) 已使用,
sum(nvl(a.bytes,0)) 剩余,
sum(nvl(a.bytes,0))/(b.bytes)*100 剩余百分比
from dba_free_space a,dba_data_files b
where a.file_id=b.file_id
group by b.tablespace_name,b.file_name,b.file_id,b.bytes
order by b.tablespace_name
查看可使用内存
df-h
手动添加
ALTER TABLESPACE 表空间 名称 ADD DATAFILE
‘/fra/oradata/hipdb/TBS_HIP_ODS_65.DBF’ SIZE 30720M;
一直再oracle操作,添加hip_cdr层内存
alter TABLESPACE HIP_CDR
ADD DATAFILE ‘/data/oradata/hipdb/HIP_CDR_06.DBF’ SIZE 30720M;