Oracle | DBMS_WRR

Oracle DBMS_WRR_REPORT Version 21c

General Information

Library Note

Morgan's Library Page Header

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.

Purpose Generates a replay report

AUTHID DEFINER

Dependencies

ALL_TAB_COLS	DBMS_DB_VERSION	PLITBLM
DBA_HIST_ACTIVE_SESS_HISTORY	DBMS_LOB	UTL_LMS
DBA_HIST_SNAPSHOT	DBMS_OUTPUT	V$SQL
DBA_HIST_SQLTEXT	DBMS_WORKLOAD_CAPTURE_LIB	WRH$_ACTIVE_SESSION_HISTORY
DBA_HIST_SYSMETRIC_HISTORY	DBMS_WORKLOAD_REPLAY_I	WRR$_REPLAYS
DBA_WORKLOAD_CAPTURES	DBMS_WRR_REPORT	WRR$_REPLAY_FILES
DBA_WORKLOAD_REPLAYS	GV$ACTIVE_SESSION_HISTORY	WRR$_REPLAY_LOGIN_QUEUE
DBA_WORKLOAD_REPLAY_DIVERGENCE	GV$SESSION	WRR$_REPLAY_SCN_ORDER
DBA_WORKLOAD_SCHEDULE_CAPTURES	GV$WORKLOAD_REPLAY_THREAD

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvtwrr_report.plb

Subprograms

REPLAY

REPORT

REPLAY

Undocumented dbms_wrr_report(id IN NUMBER);

exec dbms_wrr_report(42);

REPORT

Generates a replay report dbms_wrr_report(id IN NUMBER) RETURN CLOB;

set serveroutput on

      

      exec dbms_wrr_report.replay(42);

      Replay 42 not found

      

      PL/SQL procedure successfully completed.