Re: AW: Re: amm vs. asmm

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