查看一个事务产生的重做数量
CREATE VIEW REDO_SIZE AS
SELECT VALUE FROM V$MYSTAT,V$STATNAME
WHERE V$MYSTAT.STATISTIC#=V$STATNAME.STATISTIC# AND V$STATNAME.NAME='redo size'
/
declare
l_redo_size number;
l_cnt number:=0;
begin
select value into l_redo_size from redo_size;
pl/sql块或sql语句
select value-l_redo_size into l_redo_size from redo_size;
dbms_output.put_line('redo size=' || l_redo_size);
end;
/
阅读(659) | 评论(0) | 转发(0) |