Oracle | AS

Oracle AS_REPLAY Version 21c

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 Undocumented internal support for Workload Capture and Replay

AUTHID DEFINER

Dependencies

DBMS_WORKLOAD_REPLAY	DBMS_WRR_INTERNAL	WRR$_REPLAY_SCN_ORDER
DBMS_WORKLOAD_REPLAY_I	WRR$_REPLAYS

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 is 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;