The following points describe ways to accelerate the execution of the validation programs:
Gather Schema statistics using the DBMS_STATS PL/SQL package after data has been inserted into the staging tables. Collecting statistics at the schema level is more efficient than object by object. Be sure to specify the ‘degree’ parameter to enforce parallel statistics collection.
Object validation programs should be run multi threaded.
Execute shorter running validation processes (e.g., less records) first so that the error data can be analyzed while other processes are busy running.
Referential integrity validation programs run fairly quickly without much tuning. However, additional benefits are gained by running several programs at the same time. Monitor system resources (CPU, RAM, IO) to fine tune how many jobs can be run simultaneously.
Remember that the object validation programs can be run in "validate every nth row". We recommend running these programs using a relatively large value for this parameter until the pervasive problems have been rectified.
Copyright © 2007, 2016, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.5.2016 10:21:45 [T1_1454696505000]