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 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

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');

Note:

"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)

Cause

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