Re: Flush shared_pool
Date: Tue, 22 Jan 2008 19:38:45 +0100
"Vladimir M. Zakharychev" <vladimir.zakharychev_at_gmail.com> a écrit dans le
message de news:
> On Jan 22, 8:05 pm, "Yannick ROGER" <yannick.ro..._at_achatpro.com>
>> I want to flush the shared_pool in order to "accelerate" effects of
>> cursor_sharing parameter. What is the risk, if it exist, on a production
>> server with batch running?
> 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.
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
Thanks for your reply Received on Tue Jan 22 2008 - 12:38:45 CST