在执行返回数百万行的查询时,我会收到以下错误:
ORA-30036: unable to extend segment by 128 in undo tablespace 'UNDOTBS2'
错误告诉我溢出的撤销表空间的名称。
如何检查上面命名的撤销表空间的当前大小?
是否有一个PL/SQL命令返回有关给定撤消表空间的元数据?
发布于 2020-02-13 15:39:40
select t1.tablespace_name "Tablespace name"
, total_used_space "Used MB"
, (t1.total_space - t2.total_used_space) "Free MB"
, t1.total_space "Total MB"
, round(100 * ( (t1.total_space - t2.total_used_space)/ t1.total_space))
"Percentage Free"
from (select tablespace_name
, round(sum(bytes) / 1048576) Total_Space
from dba_data_files
group by tablespace_name) t1,
(select round(sum(bytes)/(1024*1024)) total_used_space
, tablespace_name
from dba_segments
group by tablespace_name) t2
where t1.tablespace_name = t2.tablespace_name ;https://stackoverflow.com/questions/60211441
复制相似问题