Re: Keeping stored procedures in the shared pool ?

Andre Vergison <avergison_at_infosoft.be> wrote:
>Has anybody already used the keep and unkeep functions of
>the dbms_shared_pool package ?
>
>We have an application that needs to run a specific stored procedure from
>time to time, let's say every X minutes. But the first time it is loaded

[deleted lines]

>Who has encountered similar stored procedure behaviours ? Is the keep
>function a solution ?

I encountered similar behaviour and I fix the problem using the package to pin the package in the shared_pool.

That's a good solution.

Regards,

Carlos Netto
cnetto_at_cps.softex.br Received on Tue Jan 02 1996 - 00:00:00 CET