Found a little bug. It does not seem to work with named instances. I tried putting the name in braces, but it didn't help. If I were a Powershell guru...

You may want to reconsider your use of sp_updatestats as the only way to update the statistics of the database. This normally will only sample a portion of each table...

Maybe the Oracle ODBC or OLE DB connector you are using is not multi-processor aware and that is causing issues? I'd try a different connector. Just my limited educated guess.

Use audit triggers. There are many examples on the Internet. In your trigger you can capture the master..sysprocesses.program_name that is connected to the spid.

Use the following to see what i...

This is coming really late, but the following process worked for me when trying to query DBF files using only one linked server and ODBC connection.

Installed Visual FoxPro ODBC drivers...