Re: Package Overhead

JC wrote:
> 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

This likely has nothing to do with the package. There is something else going on. What version of Oracle? What statistics have you gathered? Have you run a trace? (and if not ... now is as good a time as any).

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org