Re: Flush shared_pool

"Steve Howard" <stevedhoward_at_gmail.com> a écrit dans le message de news: 4078f2f8-ecc3-4a73-9542-6a04b8392d3b_at_21g2000hsj.googlegroups.com...
> On Jan 22, 12:05 pm, "Yannick ROGER" <yannick.ro..._at_achatpro.com>
> 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
>
> Hi Yannick,
>
> We did it about three weeks ago as a workaround for a bug. It's a 4TB
> database with a shared pool of 1GB. We saw no impact at all. Of
> course, you'll have a CPU hit when the queries are reparsed, but it
> sounds like that is what you want :)
>
> HTH,
>
> Steve

Thanks Received on Tue Jan 22 2008 - 12:32:16 CST