For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
Purpose
Produces a replay report
AUTHID
DEFINER
Dependencies
ALL_TAB_COLS
DBMS_LOB
GV$WORKLOAD_REPLAY_THREAD
DBA_HIST_ACTIVE_SESS_HISTORY
DBMS_OUTPUT
PLITBLM
DBA_HIST_SNAPSHOT
DBMS_WORKLOAD_CAPTURE_LIB
UTL_LMS
DBA_HIST_SQLTEXT
DBMS_WORKLOAD_REPLAY_I
V$SQL
DBA_WORKLOAD_CAPTURES
GV$ACTIVE_SESSION_HISTORY
WRR$_REPLAYS
DBA_WORKLOAD_REPLAYS
GV$SESSION
WRR$_REPLAY_SCN_ORDER
DBA_WORKLOAD_REPLAY_DIVERGENCE
Documented
No
First Available
Not Known
Security Model
Owned by SYS with no privileges granted.
Source
{ORACLE_HOME}/rdbms/admin/prvtwrr_report.plb
REPLAY
Produces a replay report
dbms_wrr_report(id IN NUMBER);
SQL> set serveroutput on
SQL> exec dbms_wrr_report.replay(1); Replay 1 not found
