Oracle Database Discussions

I am running some tests with a C# application (compiled in 32-bit on a Windows Server 2003 64-bit) using ODP.NET calling a procedure in Oracle 11.

The code is as listed below. The procedure SP_TEST3 has no input parameters, and only sets a local string variable. The average execution time for 2000 repetitions is 0.29 ms. Does this represent the overhead to call a procedure in Oracle?

Also, if I call another procedure that has 2 input parameters (and the procedure only sets a local string variable again), the average execution time increases to 0.44 ms. Is it normal to have such an overhead to pass input parameters?

-------------------------------------------------------------------------
while (intCount < intRepetitions)
{
oStopwatch = new System.Diagnostics.Stopwatch();
oStopwatch.Start();

strSQL = "SP_TEST3";
oCmd = new OracleCommand(strSQL, oConn);
oCmd.CommandText = strSQL;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.ExecuteNonQuery();

oStopwatch.Stop();
decMicroElapsed = (decimal)oStopwatch.Elapsed.Ticks / 10M;

intCount++;
}

Edited by: T2C on Jun 18, 2010 6:59 AM