SPEED UP ORACLE ODBC?

From: Joseph Kiok <kiok_at_i-manila.com.ph>
Date: Wed, 19 May 1999 15:04:33 +0800
Message-ID: <37426281.760F2043@i-manila.com.ph>

Hi Oracle Experts,

I'm trying to connect to Oracle via ODBC and it takes approx 16 seconds to connect and get the schema of a table.

If I'm connecting via network, it'll take 25 seconds.

Can anyone help on how to make it faster?

What is the main problem for this? The Network protocols? or the Oracle Server?

Specifics :
Server : NT WORKSTATION 4.0; Oracle 8
Connected via a 8-PORT MINI HUB.

I don't think that network traffic is the concern because there are only 4 pcs connected.

Thanks in advance, Gurus.

Regards,
Joseph Received on Wed May 19 1999 - 02:04:33 CDT