tags:

views:

72

answers:

1
Q: 

Oracle Client Tuning?

Is there a way to tune the Oracle client (InstantClient or the normal one)?

We have a software that runs on multiple DMBS (MySQL, PGSQL and MS SQL Server) I'm wondering why the Oracle version of the product consume more resources than the other ones.

UPDATE: I'm using the C++ API (OCI).

+1  A: 

Well depending on the version of oracle and client you can tune your connection to oracle, largely through using the tnsnames.ora and sqlnet.ora. you can change all sorts of things like buffer sizes, etc. This is an example of one: SDU & MTU sizes. As for resources, the DLL from the oracle client is HUGE and will consume more memory/disk space then the other ones. I know the OCI.dll we use is 100+ mb dll. Other then that I would ask you to be more specific as what resources you would like to tune?

mcauthorn  2009-10-22 02:23:54

related questions

Strange behaviour with a pl/sql query and .net
Very frustrating ORA-12154 excpetion finally resolved!
Java/Oracle: executing a prepared statement fails on a second iteration of a loop (not all variables bound). Why?
ADO.NET & Oracle: Getting Line Number Info When Script Execution Fails
Converting from DbCommand object to OracleCommand object
Constructing a good search query using system.data.oracleclient
OracleClient to devart dotConnect for Oracle
Why does OracleParameter implement ICloneable but doesn't provide Clone()?
OracleConnection.ClearAllPools - Operation is not valid due to the current state of the object
Anyone have any luck installing Oracle10g Client 64-bit 10.2.0.3 on Windows 7 x64 RTM?
Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
Why do I get Oracle connection errors only in a VS 2008 web app/site project?
Unable to set up ODBC after installing ODAC (Xcopy)
How do I specify which Oracle client install to use?
System.Data.OracleClient namespace discontinued?
Oracle .NET error - Wrong number or type of arguments
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception
Oracle Connection and nls_lang
Oracle connection string without tnsnames.ora file
Use Oracle 6 from ASP.NET application
ADO.NET, Closing an OracleConnection without prior Commit or Rollback: Will it leak?
Debugging .Net OracleClient error
Connect to an Oracle 8i database using a 10g client
How can I mock/fake/stub sealed OracleException with no public constructor?