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
dotConnect for Oracle - v5.0.40.0 - How to set PACKET SIZE
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?
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?
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
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
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 .
The Direct mode is described in our documentation here:
http://www.devart.com/dotconnect/oracle ... tMode.html .