Oracle | AS

Oracle AS_REPLAY Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

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;