| René Nyffenegger's collection of things on the web | |
|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Package to determine amount of redo generated in Oracle | ||
|
The following package and table allow to find out how much redo has been genearated
between two calls of the procedure.
reate table last_redo_size as select value redo_size
from v$sysstat where name = 'redo size';
create or replace package redo_diff as
procedure diff_it;
end;
/
create or replace package body redo_diff as
s number;
function get_size return number is
s_ number;
begin
select value into s_ from sys.v_$sysstat where name = 'redo size';
return s_;
end get_size;
procedure diff_it is
s_new number;
begin
s_new := get_size;
dbms_output.put_line('redo diff: ' || to_char(s_new - s));
s := s_new;
end diff_it;
begin
s := get_size;
end;
/
This package is demonstrated in creating global temporary tables
|