this is really slow. It could be related to the VM, to the network (firewalls?) or to the database (table or view?) itself. How is the performance from another client?
To proof it is not related to OLEDB/ODBC setup you can try our JDBC connector:
If this setup it's also this slow I tend to say you should ask your Oracle and network admin.
Not sure exactly how, but we did a few round of uninstall and reinstall of the windows and reapply the driver in different sequence, including the Java runtime.
We think it was becoz in the Client machine build image, they were using some drivers setting from the windows 2003 days, which somehow clash with win2008, and caused the ODBC/OLE driver to behave badly.
But its now working ok, after many reinstall and test of driver install seq.
Sorry, not much help, as I don't and cannot understand/explain how we did it, but it was a problem with the driver package + java in some shape that caused the problem.