|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