Re: Slow response with packaged varaibles...

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 08 Jul 2003 23:07:20 GMT
Message-ID: <I8IOa.25$Mx6.16@news02.roc.ny>

"Steve Howard" <stephen.howard_at_us.pwcglobal.com> wrote in message news:6d8b7216.0307081017.d9bb749_at_posting.google.com...
> Oracle 8.1.7.3 on HPUX 11.0
>
> In our third party developed app, I have noticed the response time
> with packaged variables, or anything _not_ hardcoded, seems to much
> slower than hardcoding. See below:
>

---snip--
> Does anyone have any insight as to why is the variable version so much
> slower than the hardcoded value?
>
> Thanks,
>
> Steve

Run explain plan on both statements and see what the difference is. Most probably the literal version is using an index and the bind version is not. Also post how/whether you analyzed the tables/indexes and what are the values of optimizer_* parameters.

Search Google if you don't know how to get the explain plan

Anurag Received on Tue Jul 08 2003 - 18:07:20 CDT