On Wed, Jun 16, 2010 at 1:15 PM, Craig Ringer
wrote:
> On 16/06/10 16:56, Allan Kamau wrote:
>
>> The function I have mentioned above seems to "hang" indefinitely (now
>> 12hours and counting) while it took only 2secs for the many times it
>> was previously invoked from the client application (wit
On Wed, Jun 16, 2010 at 1:15 PM, Craig Ringer
wrote:
> On 16/06/10 16:56, Allan Kamau wrote:
>
>> The function I have mentioned above seems to "hang" indefinitely (now
>> 12hours and counting) while it took only 2secs for the many times it
>> was previously invoked from the client application (wit
On 16/06/10 16:56, Allan Kamau wrote:
> The function I have mentioned above seems to "hang" indefinitely (now
> 12hours and counting) while it took only 2secs for the many times it
> was previously invoked from the client application (with slightly
> different parameter value at each such time).
On Tue, Jun 15, 2010 at 5:03 PM, Allan Kamau wrote:
> I do have a PL/SQL function that gets executed called many times but
> with different parameter values each of these times. For most
> invocations of this function run in a couple of seconds however some
> invocations of the same function run (