Oracle | DBMS_WRR

Oracle DBMS_WRR_REPORT Version 21c

General Information

Library Note

Morgan's Library Page Header

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 asra_us@oracle.com. Request a Workshop for your organization today.

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.