Re: FW: ASMM
- From: Seth Miller <sethmiller.sm@xxxxxxxxx>
- To: Brian.Zelli@xxxxxxxxxxxxxxx
- Date: Wed, 14 May 2014 22:47:22 -0500
Brian,
I haven't seen a problem identified yet. Are you trying to fix some kind of
performance issue? Do you have reason to believe that your Library Cache
Get Hit Ratio is the source of a problem you have identified?
AMM and ASMM do not preclude you from tuning your individual pools. You can
continue to use either one or both and increase your shared pool size by
setting the parameter manually. That setting will then act as a floor for
the pool.
Seth Miller
On Mon, May 12, 2014 at 9:42 AM, Zelli, Brian
<Brian.Zelli@xxxxxxxxxxxxxxx>wrote:
> Forgot to include the group…..
>
>
>
>
>
> I am finding that my Library Cache Get hit Ratio % is hovering around
> 50-60 percent. I read that the value should be above 90%. I read that
> the recommendation is to increase the shared pool size. I am running AMM
> and I set the memory_target twice what it was and still no relief…..
>
>
>
>
>
> Brian
>
>
>
>
>
> *From:* Chris Taylor
> [mailto:christopherdtaylor1994@xxxxxxxxx<christopherdtaylor1994@xxxxxxxxx>]
>
> *Sent:* Monday, May 12, 2014 10:38 AM
> *To:* Zelli, Brian
> *Cc:* oracle-l (oracle-l@xxxxxxxxxxxxx)
> *Subject:* Re: ASMM
>
>
>
> Brian,
>
>
>
> The answer to your question is "it depends". What are you running now?
> (AMM I assume?) What is your goal? Are you trying to solve a problem you
> think is related to AMM or a non-AMM configuration? There's not a black
> and white answer to your question. With some more details people "might"
> be able to offer some insight/suggestions.
>
>
>
> Regards,
>
> Chris
>
>
>
>
>
> On Mon, May 12, 2014 at 9:29 AM, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx>
> wrote:
>
> Question for all you folks. I have an 11g instance and I was wondering if
> I should switch to Automatic Shared Memory Management. Easier? Better?
>
>
>
>
>
> 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.
>
>
>
> 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.
>
Other related posts:
