Timothy, 

Here are the things we're doing to get the best performance from our Oracle 9 linked servers:

* use the Oracle OLE DB provider

* update the server's registry per KB article...

One item to note: if you can get by with running the package with Oracle connections interactively from Enterprise Manager (vs. a scheduled job via SQL Server Agent), DTS will...