Oracle 表空间操作相关

-- 查看表空间文件信息
select df.BYTES/1024/1024/1024 as size_GB, df.* from dba_data_files df where df.TABLESPACE_NAME='GEODATA';

-- 扩展表空间
alter tablespace GEODATA add datafile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\GEODATA34.DBF' size 30G;

-- 查看临时表空间使用情况
select c.tablespace_name,
to_char(c.bytes/1024/1024/1024,'99,999.999') total_gb,
to_char( (c.bytes-d.bytes_used)/1024/1024/1024,'99,999.999') free_gb,
to_char(d.bytes_used/1024/1024/1024,'99,999.999') use_gb,
to_char(d.bytes_used*100/c.bytes,'99.99') || '%'use
from  (select tablespace_name,sum(bytes) bytes
from dba_temp_files GROUP by tablespace_name) c,
(select tablespace_name,sum(bytes_cached) bytes_used
from v$temp_extent_pool GROUP by tablespace_name) d
where c.tablespace_name = d.tablespace_name;

-- 扩展临时表空间
alter tablespace temp add tempfile 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\TRMP02.DBF' size 4G;