Re: sga
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
- Date: Fri, 12 Jun 2009 08:30:24 -0500
If the issue is lack of bind variables (too much dynamic sql), you can think
about setting cursor_sharing=force, that solution has other problems
however.
On Fri, Jun 12, 2009 at 8:26 AM, Mathias Magnusson <
mathias.magnusson@xxxxxxxxx> wrote:
> Do you know that it causes a problem? What is your key wait event that this
> will address and how much do you spend waiting for it? Where do you find
> this ratio recommendation?
>
> Mathias
>
>
> On Fri, Jun 12, 2009 at 3:04 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:
>
>> Well, adding memory is an option. You should also look at your code. If
>> you are not using bind variables, that can also cause the problem, and it is
>> almost impossible to fix that problem just by adding memory.
>>
>>
>> On Fri, Jun 12, 2009 at 8:01 AM, Zelli, Brian <
>> Brian.Zelli@xxxxxxxxxxxxxxx> wrote:
>>
>>> Ok, so I have my sga tuned by the advisor in 10g but I have a library
>>> cache hit ratio constantly below the recommended threshold of 90%. How the
>>> heck do I tune it? Do I just increase the sga_target?
>>>
>>>
>>> ciao,
>>>
>>> Brian
>>>
>>>
>>>
>>>
>>> This email message may contain legally privileged and/or confidential
>>> information. If you are not the intended recipient(s), or the employee or
>>> agent responsible for the delivery of this message to the intended
>>> recipient(s), you are hereby notified that any disclosure, copying,
>>> distribution, or use of this email message is prohibited. If you have
>>> received this message in error, please notify the sender immediately by
>>> e-mail and delete this email message from your computer. Thank you.
>>
>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
