Package Overhead

Hi,

In the process of investigating a slow running query I noticed that there was approximately a 1 second difference in execution time for a SELECT statement inside our package procedure and the same SELECT statement executed outside the package procedure (at command prompt). I knew there was some package overhead, but not quire that much.

Eg) 1) SELECT * from test_table ( .15 seconds execution time)

        2) EXEC test_package.test_procedure (1.16 seconds execution time)

	        Package test_package
	        ...
	        Procedure test_procedure
		...
		SELECT * from test_table

	(all that is in the package procedure is the select statement)

Does anyone know why the package procedure call would take 1 second longer (I assume it might be because of compilation)? Is there a way to either cut down or eliminate this overhead?

Thanks,
JC Received on Tue Jun 13 2006 - 11:04:06 CDT