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.