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
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.

Related Topics
Built-in Functions
Built-in Packages
DBMS_WORKLOAD_REPLAY
DBMS_WRR_INTERNAL
DBMS_WRR_PROTECTED
DBMS_WRR_STATE
DBMS_WRR_STATE_BASE
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx