Oracel 表空间增大

--1.查看表空间利用率
SELECT a.tablespace_name "表空间名",

a.bytes / 1024 / 1024 "表空间大小(M)",

(a.bytes - b.bytes) / 1024 / 1024 "已使用空间(M)",

b.bytes / 1024 / 1024 "空闲空间(M)",

round(((a.bytes - b.bytes) / a.bytes) * 100, 2) "使用比"

FROM (SELECT tablespace_name, sum(bytes) bytes

FROM dba_data_files

GROUP BY tablespace_name) a,

(SELECT tablespace_name, sum(bytes) bytes, max(bytes) largest

FROM dba_free_space

GROUP BY tablespace_name) b

WHERE a.tablespace_name = b.tablespace_name

ORDER BY ((a.bytes - b.bytes) / a.bytes) DESC

--2.查看表空间位置及文件
select tablespace_name, file_id, file_name,
round(bytes/(1024*1024),0) total_space 
from dba_data_files order by tablespace_name;

--3追加表数据文件
alter tablespace GYDB_SPACE1 add 
datafile 'G:\MESDB\GSDB03\GYDB_SPACE51.DBF' size 10G --初始大小
autoextend on maxsize 30G; --正式表空间，自动增长最大30G