RAT Preprocessing Is Very Slow - Over 10 hours for Workload Capture Of 1 Hour
Last updated on SEPTEMBER 18, 2014
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
Pre-processing of the captured queries appears to be hung...it had been running for over 10 hours and had not completed yet.
SQL> exec DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE (capture_dir => 'DB_REPLAY_CAPTURE_DIR');
"DB_REPLAY_CAPTURE_DIR" can be any directory designated to contain the captured workload
System state dump taken during the hang indicated the process was executing the following sql statement:
SELECT count(*) FROM WRR$_REPLAY_DEP_GRAPH_TMP WHERE (file_id_dep = :fid AND file_id IS NOT NULL)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms