AW: Re: AW: Re: amm vs. asmm

it is just an observation that we have made in the past. After we heard that there are problems with AMM (I guess from you too in DOAG :-) ). I did few performance tests and have very negative impact of AMM on our application. In addition to that I doubt that the DBA has a factual reason to use AMM. It was may be only coincidence. Furthermore I'm worried that someone will look elsewhere for current performance problems. For example, to believe that the solution is to use a different OS ;-)

Grüße
Ahmed

Gesendet mit der Telekom Mail App

• Original-Nachricht --- Von: Stefan Koehler Betreff: Re: AW: Re: amm vs. asmm Datum: 24.01.2020, 9:22 Uhr An: ahmed.fikri_at_t-online.de Cc: oracle-l_at_freelists.org

_at_font-face { font-family: telegrotesk-medium_normal; src: url("file:///android_asset/fonts/telegrotesk_normal.ttf");}html,body { font-family: "telegrotesk-medium_normal"; font-size: medium; color: #4b4b4b; width: 100%;}

Hello Ahmed,
do you wanna describe the problem that you currently have/face with AMM or is it more like "we have a performance/functional problem in this database and in my experience we had problems with AMM in the past - so let's try this"

The mentioned huge pages advantage (or large pages what it is called on AIX) with ASMM is not such a big deal in a lot of the AIX environments as Oracle already uses 64K (medium) pages on AIX instead of the 4K pages on Linux - however if you have a really large SGA and a lot of processes, it might be an useful option too.

So back to the original question: What is the problem that you wanna solve with the change from AMM to ASMM or why do you try to convince the DBA? :-)

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> " ahmed.fikri_at_t-online.de" < ahmed.fikri_at_t-online.de> hat am 23. Januar
2020 um 19:27 geschrieben:
>
> it is Aix Os.
>
> Regards
> Ahmed
>
> On Thu, Jan 23, 2020 at 5:39 PM ahmed.fikri_at_t-online.de <
ahmed.fikri_at_t-online.de> wrote:
> > Hi,
> >
> > Coincidentally, I have seen in a productive DB that it is used AMM
instead of Asmm. I'm a developer with a bit of a dba knowledge. Our software uses a huge db and does complex calculations.
> > In my experience, using amm we had only problems with other customers
on 11g and 12c
> >
> > In addition, I have read many articles, that recommend to use asmm
instead of amm.
> > The DBA is ready to use Asmm, but only if I convince him.
> >
> > The question: It is true that amm is not good (huge db, lot of
sessions, parallels work)
> > If I'm right how can I connvince the dba?
> >
> > Thanks
> > Ahmed

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l