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