Re: Flush shared_pool

From: Yannick ROGER <>
Date: Tue, 22 Jan 2008 19:38:45 +0100
Message-ID: <fn5d62$2tb$>

"Vladimir M. Zakharychev" <> a écrit dans le message de news:
> On Jan 22, 8:05 pm, "Yannick ROGER" <>
> wrote:
>> Hi,
>> I want to flush the shared_pool in order to "accelerate" effects of
>> changing
>> cursor_sharing parameter. What is the risk, if it exist, on a production
>> server with batch running?
>> Regards,
>> Yannick
> Currently executing statements will not be flushed, so your batch is
> perfectly safe (unless it's external, in which case all statements
> submitted after the flush will be re-parsed.) As Steve said, you will
> see a hit on CPU for a while, similar to one experienced when the
> instance is just started and the shared pool is initially populated.
> Other than that, no risks are known to be associated with this
> operation (at least to me,) except the obvious risk associated with
> change of system parameter like cursor_sharing.
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)

Thanks for your reply Received on Tue Jan 22 2008 - 12:38:45 CST

Original text of this message