RAT Preprocessing Is Very Slow - Over 10 hours for Workload Capture Of 1 Hour

(Doc ID 1453842.1)

Last updated on SEPTEMBER 18, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 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.




"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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms