Oracle undo 参数查看及表空间查看
undo参数
SQL> show parameter undo
查询UNDO表空间情况
SELECT tablespace_name, status, SUM (bytes) / 1024 / 1024 "Bytes(M)"
FROM dba_undo_extents
GROUP BY tablespace_name, status;
-- 刘轶鹤
Oracle undo 参数查看及表空间查看
undo参数
SQL> show parameter undo
查询UNDO表空间情况
SELECT tablespace_name, status, SUM (bytes) / 1024 / 1024 "Bytes(M)"
FROM dba_undo_extents
GROUP BY tablespace_name, status;
-- 刘轶鹤