slow odbc after some intensive data access.

From: John <i676373_at_gmail.com>
Date: Tue, 28 Aug 2007 20:28:21 -0700
Message-ID: <1188358101.011552.197950@l22g2000prc.googlegroups.com>

Hi,

I have a oracle server configure to receive ODBC call (oracle odbc interface). One of us tried to run a data migration from Access file to the Oracle through odbc at the server for a few millions records. Then we experienced a very slow odbc accessing speed, when we ran an application at the server side. But if we ran the application remotely, and use the odbc at the remote pc, then speed is normal.

What is the reason for that?

Thanks.

Regards,
John. Received on Tue Aug 28 2007 - 22:28:21 CDT