Data Mover with Ignore_dups command in Oracle 10 runs very slowly

 

Summary:
					E-ORCL: Data Mover with Ignore_dups command in Oracle 10 runs very slowly
			Details:		SOLUTION 201014244: E-ORCL:  Data Mover with Ignore_dups command in Oracle 10 runs very slowly SPECIFIC TO:  Enterprise, Oracle 10 ISSUE: Running a Peoplesoft delivered data mover script with has the command coded in it set ignore_dups; on the Oracle 10 database.   Is observing that the script is running terribly slowly and wondering if this will ever finish? SOLUTION: This is reported in incident 1463561000.   The WORKAROUND for the ignore_dups problem in Oracle 10g: delete statistics from the following data dictionary tables sys.CDEF$ , sys.CON$  and sys.USER$ KEYWORDS:   SPOTLIGHT, ORACLE 10

--
Murali Vanamamalai
muralivana@gmail.com
302.494.3584  - cell
707.220.2719  - fax