问题
解决办法
第一步:查询各表空间使用率
SELECT total.tablespace_name,
Round(total.MB, 2) AS Total_MB,
Round(total.MB - free.MB, 2) AS Used_MB,
Round(( 1 - free.MB / total.MB ) * 100, 2)
|| '%' AS Used_Pct
FROM (SELECT tablespace_name,
Sum(bytes) / 1024 / 1024 AS MB
FROM dba_free_space
GROUP BY tablespace_name) free,
(SELECT tablespace_name,
Sum(bytes) / 1024 / 1024 AS MB
FROM dba_data_files
GROUP BY tablespace_name) total
WHERE free.tablespace_name = total.tablespace_name;
第二步:查询各表空间的实体文件位置
select tablespace_name, file_id, file_name,round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name
第三部:根据结果,增加表空间文件
以USERS表为例:
ALTER TABLESPACE users ADD DATAFILE 'D:\PTC\WINDCHILL_11.0\OCU\ORADATA\WIND\WINDUSERS02.DBF' size 3000M
标签:1024,USERS,MB,RAWSERVLETREQUESTSTATS,free,tablespace,total,name
From: https://www.cnblogs.com/yorshika/p/16774793.html