1.query undo_redo before size.(use view is convenience)

点击(此处)折叠或打开

CREATE OR REPLACE VIEW
点击(此处)折叠或打开
1. select * from V_REDO_UNDO_volumn.
AS
SELECT (SELECT NB.VALUE FROM V$MYSTAT NB, V$STATNAME ST WHERE NB.STATISTIC# = ST.STATISTIC# AND ST.NAME = 'redo size') REDO,
(SELECT NB.VALUE from V$MYSTAT NB, V$STATNAME ST WHERE NB.STATISTIC# = ST.STATISTIC#
AND ST.NAME = 'undo change vector size') UNDO
FROM DUAL

2.execute update operator
3.quer view v_redo_undo_volumn against.

ITPub博客

undo_redo_generate_volumn_test