Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Fri Jan 22 00:45:54 2016
Starting background process VKRM
Fri Jan 22 00:45:54 2016
VKRM started with pid=19, OS id=1904
Fri Jan 22 00:48:14 2016
Index SUPERMAG.FFDOCUMENTS_CLIENTIDX or some [sub]partitions of the index have been marked unusable
Index SUPERMAG.FFDOCUMENTS_SALEDATEIDX or some [sub]partitions of the index have been marked unusable
Index SUPERMAG.FFDOCUMENTS_INCOMEDATEIDX or some [sub]partitions of the index have been marked unusable
Index SUPERMAG.FFDOCUMENTS_CREATEDAT or some [sub]partitions of the index have been marked unusable
Index SUPERMAG.FFSPEC_CAUSEIDX or some [sub]partitions of the index have been marked unusable
Index SUPERMAG.FFSPEC_ART or some [sub]partitions of the index have been marked unusable
Index SUPERMAG.FFPRODDOCUMENTS_DATE or some [sub]partitions of the index have been marked unusable
Index SUPERMAG.FFPRODDOCUMENTS_ZONE or some [sub]partitions of the index have been marked unusable
Index SUPERMAG.FFPRODINSPEC_ZONEART or some [sub]partitions of the index have been marked unusable
Index SUPERMAG.FFPRODOUTSPEC_ZONEART or some [sub]partitions of the index have been marked unusable
Fri Jan 22 00:48:16 2016
Starting background process SMCO
Fri Jan 22 00:48:16 2016
SMCO started with pid=37, OS id=6728
Fri Jan 22 00:48:35 2016
Thread 1 cannot allocate new log, sequence 384
Private strand flush not complete
Current log# 2 seq# 383 mem# 0: D:\APP\USER\ORADATA\TALE01\REDO02.LOG
Thread 1 advanced to log sequence 384 (LGWR switch)
Current log# 3 seq# 384 mem# 0: D:\APP\USER\ORADATA\TALE01\REDO03.LOG
Так расчет товародвижения отключает индексы перед загрузкой данных sql-loader. Загружает данные, потом включает индексы и делает индексацию.
Т.е. все нормально, как и должно быть.