:

ORA-15590: encountered incomplete workload capture files

The Problem

I had captured the workload from our production database, copied the workload  capture files to a development database server, upgraded the development database from 10g to 11g  and then attempted to run in this procedure and received the error below:

SQL> BEGIN
2    DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE  (capture_dir => ‘WRC’);
3    END;
4    /
BEGIN
*
ERROR at line 1:

ORA-15590: encountered incomplete workload capture files
ORA-06512: at “SYS.DBMS_WORKLOAD_REPLAY”, line  2010
ORA-06512: at line 2

The Cause

This is merely an informational message stating that some of  the files which were processed had incomplete transactions running when the  capture process was terminated. This does not mean that the pre-process stage  was not successful, as it probably worked just fine. When replaying the capture  you might have some unfinished transactions in the DB and therefore it will  increase your divergence results.

In my case I think that the sessions remained connected for  a long time because my capture was only running from 5.30am until midday, but  the timestamp on the file which it gave the above error for was 11.59pm on that  same day.

The Solution

I continued to use these files for my testing and they  worked just fine, and the pre-process stage had indeed finished without any  issues.

In an ideal world, the capture process would be started before any sessions log on to the DB and are disconnected before the capture  stops.

You might also be having problems enabling Real Application Testing (RAT) within your database.

Like it, share it...

Category: RAT


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *