I have an Excel file (XLSX) I use to import data from into an Oracle table using the ‘Import Table Data’ object in Automation Designer.
However in the past couple of weeks it appears to be running much slower than it used to.
The file contains approximately 8000 rows and 8 columns.
The table is truncated during the import process and I select ‘Use Array DML’ iwth an array size of 500.
Prior to a couple of weeks ago this process would take approximately 5 seconds to complete.
Now it is taking well over a minute.
I haven’t modified anything within Toad.
I even upgraded from 12.0.99 to 12.5.1 to see if this helped.
Does anyone have any ideas as to why this would happening?
Thanks for any advice.