Oracle AS_REPLAY Demos

Oracle AS_REPLAY Version 11.2.0.3

General Information

AUTHID

DEFINER

Dependencies

DBMS_WORKLOAD_REPLAY

WRR$_REPLAYS

WRR$_REPLAY_SCN_ORDER

First Available

11.2

Security Model

Owned by SYS: Execute is granted to the roles DBA and EXECUTE_CATALOG_ROLE

Source

{ORACLE_HOME}/rdbms/admin/prvtwrr.plb

Subprograms

END_AS_REPLAY	PREPARE_AS_REPLAY	START_AS_REPLAY
INITIALIZE_AS_REPLAY	PROCESS_AS_CAPTURE

END_AS_REPLAY

Undocumented

as_replay.end_as_replay;

exec as_replay.end_as_replay;

INITIALIZE_AS_REPLAY

Undocumented

as_replay.initialize_as_replay(replay_name IN VARCHAR2, replay_dir IN VARCHAR2);

exec as_replay.initialize_as_replay('UWReplay', 'CTEMP');

PREPARE_AS_REPLAY

Undocumented

as_replay.prepare_as_replay(
synchronization         IN BOOLEAN,
connect_time_scale      IN NUMBER,
think_time_scale        IN NUMBER,
think_time_auto_correct IN BOOLEAN,
scale_up_multiplier     IN NUMBER);

TBD

PROCESS_AS_CAPTURE

Undocumented

as_replay.process_as_capture(capture_dir IN VARCHAR2, parallel_level IN NUMBER);

exec as_replay.process_as_capture('CTEMP', 2);

START_AS_REPLAY

Undocumented

as_replay.start_as_replay;

exec as_replay.start_as_replay;