Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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