| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Slow ODBC connectivity
We have a problem with a remote S-Plus server that connects to Oracle 8i on
UNIX via ODBC.
The Oracle 8i server is painfully slow at sending packets back to the client.
I upgraded the ODBC driver on the client to that latest 8i driver, that made a small difference. I unchecked most of the options for ODBC, that helped a bit too.
I also discovered the monster query that ODBC submits whenever it connects, picking up all the java classes in the rdbms (LOL!). The workaround for that is to create local views in the user's schema for all_synonyms and all_objects, I asked the developers if they can do that for us.
I also set SDU and TDU to the maximum values, we noticed a small performance improvement. I read about multiples of 1460 or 1461 (not clear which is best so I changed the values back down to 1460). A page on the 'net says set it to the max value, a Don Burleson page says on Ethernet set it to 1514 (I think that's what he says, "On standard Ethernet networks, the default MTU size is set to 1,514 bytes"). Don also says that Oracle recommends that MTU and SDU be the same, certainly SDU is not supposed to be larger than MTU. I am starting to wonder whether we need a second TNS listener on the unix machine, would that speed up the response time?
Any ideas on how to speed up connectivity through ODBC?
No, we can't stop using ODBC... I tried suggesting that many times.
Patrice.
 |
 |