Oracle | AS

Oracle AS_REPLAY Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Undocumented internal support for Workload Capture and Replay

AUTHID DEFINER

Dependencies

DBMS_WORKLOAD_REPLAY_I	WRR$_REPLAYS	WRR$_REPLAY_SCN_ORDER
DBMS_WRR_INTERNAL

Documented No

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to the DBA and EXECUTE_CATALOG_ROLE roles

Source {ORACLE_HOME}/rdbms/admin/prvtwrr.plb

AS_REPLAY was not installed, by default in 23.2. The package body installs in an invalid state due to missing objects such as DBMS_WORKLOAD_REPLAY_I (invalid) and DBMS_WRR_INTERNAL (both header and body invalid).

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 VARCHAR2 DEFAULT 'ASR', connect_time_scale IN NUMBER DEFAULT 100, think_time_scale IN NUMBER, think_time_auto_correct IN BOOLEAN DEFAULT TRUE, scale_up_multiplier IN NUMBER DEFAULT 1);

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;