Search notes:
Oracle: DBA_WORKLOAD_REPLAY_THREAD
dba_workload_replay_thread
lists the session histories for every replay.
The view selects from wrr$_workload_replay_thread
.
select
thr.call_counter,
thr.capture_elapsed_time,
thr.dbtime,
thr.file_id,
thr.file_name,
thr.inst_id,
thr.is_scale_up_sess,
thr.logon_time,
thr.logon_user,
thr.network_time,
thr.plsql_calls,
thr.plsql_dbtime,
thr.plsql_subcalls,
thr.replay_dir_number,
thr.replay_elapsed_time,
thr.schedule_cap_id,
thr.sid,
thr.serial#,
thr.session_type,
thr.spid,
thr.think_time,
thr.user_calls,
thr.wrc_id
from
sys.dba_workload_replay_thread thr;