We are tryig to access Oracle for all Test Data. But it is very slow in connectivity and data fetching.
Anybody has any advice?
Logica Pvt Ltd
Outside of using some type of utility to diagnose a network problem, make sure that you do not have tracing enabled in your ODBC administrator. Having it enabled can grind things almost to a halt.
How are you pulling the data down?
I pull data down to work with from an Oracle db... but I utilize 'spool' to pull it in.
Disclaimer: I am forever a newbie!