| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Generates a replay report: In 23ai this package is no longer installed by default |
| AUTHID |
DEFINER |
| Dependencies |
| ALL_TAB_COLS |
DBMS_WORKLOAD_REPLAY_I |
| DBA_HIST_ACTIVE_SESS_HISTORY |
GV$ACTIVE_SESSION_HISTORY |
| DBA_HIST_SNAPSHOT |
GV$SESSION |
| DBA_HIST_SQLTEXT |
GV$WORKLOAD_REPLAY_THREAD |
| DBA_HIST_SYSMETRIC_HISTORY |
PLITBLM |
| DBA_WORKLOAD_CAPTURES |
UTL_LMS |
| DBA_WORKLOAD_REPLAYS |
V$SQL |
| DBA_WORKLOAD_REPLAY_DIVERGENCE |
WRH$_ACTIVE_SESSION_HISTORY |
| DBA_WORKLOAD_SCHEDULE_CAPTURES |
WRR$_REPLAYS |
| DBMS_DB_VERSION |
WRR$_REPLAY_FILES |
| DBMS_LOB |
WRR$_REPLAY_LOGIN_QUEUE |
| DBMS_OUTPUT |
WRR$_REPLAY_SCN_ORDER |
| DBMS_WORKLOAD_CAPTURE_LIB |
|
|
| Documented |
No |
| First Available |
Not Known |
| Security Model |
Owned by SYS with no privileges granted. |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtwrr_report.plb
In 23ai this package is no longer installed by default. |
| Subprograms |
|
| |
| REPLAY |
| Undocumented |
dbms_wrr_report(id IN NUMBER); |
exec dbms_wrr_report(42);
PL/SQL procedure successfully completed. |
| |
| 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. |