内容阅读
在知识库中专注阅读，并随时返回相关工具与课程
在知识库中专注阅读，并随时返回相关工具与课程
Unable to extend segment by in undo tablespace
Undo 表空间已满，无法为事务 undo 数据分配更多空间。
SELECT tablespace_name, SUM(bytes)/1024/1024 size_mb FROM dba_data_files WHERE tablespace_name = (SELECT value FROM v$parameter WHERE name = 'undo_tablespace') GROUP BY tablespace_name;SELECT s.sid, s.username, t.used_ublk * 8192/1024/1024 undo_mb FROM v$session s JOIN v$transaction t ON s.saddr = t.ses_addr ORDER BY t.used_ublk DESC;