ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
email@example.com. Request a Workshop for
your organization today.
The source code for the package specification and body are listed below but the origin of how it got into the 21.3 database, and what it is intended to accomplish, is still a mystery.
That said, it is a decent piece of work and I want to thank whoever thought to put it there.
Owned by SYS with no privileges granted
Source: Formatted for clarity
grep -ir "REDO_DIFF"
did not identify a single file that contained this string.
CREATE OR REPLACE NONEDITIONABLE PACKAGE "SYS"."REDO_DIFF" AUTHID DEFINER IS
CREATE OR REPLACE NONEDITIONABLE PACKAGE BODY "SYS"."REDO_DIFF" IS
FUNCTION get_size RETURN NUMBER IS
WHERE name = 'redo size';
PROCEDURE diff_it IS
s_new := get_size;
dbms_output.put_line('redo diff: ' || TO_CHAR(s_new - s));
s := s_new;
-- intialization section
s := get_size;
DIFF_IT (new 21c)
Reports the amount of redo generated in by the system from the time of initialization in the current session until it is rerun