thanks a lot for the information. especially the remark about AIX.
Regards
Ahmed
------------------------------------------------------------------------
Gesendet mit der Telekom Mail App
<https://kommunikationsdienste.t-online.de/redirects/email_app_android_sendmail_footer>
--- Original-Nachricht ---
Von: Stefan Koehler
Betreff: Re: AW: Re: AW: Re: amm vs. asmm
Datum: 24.01.2020, 10:46 Uhr
An: ahmed.fikri@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Hello Ahmed,
there are also problems with ASMM, e.g.
https://twitter.com/jolliffe/status/1094195271448186881?s=20
<https://twitter.com/jolliffe/status/1094195271448186881?s=20> .
There is no better way than doing malloc() or mmap() on your own - just
kidding ;-)
I see no reason to change Oracle's memory management if nobody currently
faces any issue. However in general I personally favor ASMM (or completely
manual SHM management) from the start but why changing something that does
work right now in your case. By the way even some guys from Oracle do not
favor AMM in first place, e.g.
https://twitter.com/MikeDietrichDE/status/666564901536727040?s=20
<https://twitter.com/MikeDietrichDE/status/666564901536727040?s=20> or
https://mikedietrichde.com/2016/03/04/parameter-recommendations-for-oracle-database-12c-part-i
<https://mikedietrichde.com/2016/03/04/parameter-recommendations-for-oracle-database-12c-part-i>
/
P.S.: Moving Oracle away from AIX is almost always a good idea (not just in
case of current problems). IMHO there is only one good reason (real need
for best single thread CPU performance) to stay on Power / AIX - but then
you need to configure SMT carefully and benchmark it as well.
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de ;<http://www.soocs.de>
Twitter: @OracleSK <mailto:@OracleSK>
"ahmed.fikri@xxxxxxxxxxx <mailto:ahmed.fikri@xxxxxxxxxxx> " <ahmed.fikri@xxxxxxxxxxx <mailto:ahmed.fikri@xxxxxxxxxxx> > hat am 24.
that there are problems with AMM (I guess from you too in DOAG :-) ). I did
hello Steffen,
it is just an observation that we have made in the past. After we heard
Grüße
Ahmed