Page 1 of 1
dotConnect for Oracle - v5.0.40.0 - How to set PACKET SIZE
Posted: Mon 15 Mar 2010 15:05
by bri_001
Hello,
I use dotConnect for Oracle Pro - v5.0.40.0 to connect to an Oracle 10g db with direct mode. I would like to set the packet size manually via connection string. If I cannot do this via connection string, is there another way?
Also, can someone post a list of all "Devart-recognized" named connection string parameters?
Thank you in advance
Posted: Tue 16 Mar 2010 10:40
by Shalex
You can find the full list of the valid names for values within ConnectionString
here.
The packet size parameter of the connection string is not available in the OCI mode because data transfer is controlled by Oracle Client in this case, and we cannot guarantee that the packet size will be exactly as it was set. We will consider the possibility of adding this feature in the Direct mode. Could you please tell us why this functionality is so critical for you?
Posted: Tue 16 Mar 2010 15:19
by bri_001
Thank you for your reply.
My application supports users located in different states. There have been complaints about performance from users in locations farther away from the database server. It was recommended that we increase packet size to remove some of the latency.
The application uses direct mode to connect to the server because I cannot enforce what Oracle client(s) are installed on the user PC.
Would it be possible to make a new feature request for this?
I have one more question (and this is probably wishful thinking). When I use direct mode, does the Devart client ignore the TNS configuration in tnsnames.ora? I see that HOST and PORT is required, but I has hoping that I could supply packet size (i.e. TNS) in tnsnames.ora.
Thanks again
Posted: Wed 17 Mar 2010 14:47
by Shalex
We cannot tell when exactly the packet size feature is implemented.
If you are working in the Direct mode, the Oracle Client software is not used, and its settings from the tnsnames.ora file are not taken into account.
Posted: Mon 12 Apr 2010 15:25
by Shalex
Please control the buffer size with the
FetchSize property of OracleCommand.
Posted: Fri 09 Jul 2010 14:19
by Shalex
The 5.70.146 build of dotConnect for Oracle includes static property Devart.Data.Oracle.DirectUtils.PacketSize. It allows to control the packet size only in the Direct mode. We cannot guarantee that the packet size will be exactly as it was set in the OCI mode, because data transfer is controlled by Oracle Client in this case.
The Direct mode is described in our documentation here:
http://www.devart.com/dotconnect/oracle ... tMode.html .