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: @OracleSK
"ahmed.fikri@xxxxxxxxxxx" <ahmed.fikri@xxxxxxxxxxx> 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@xxxxxxxxxxx <
ahmed.fikri@xxxxxxxxxxx> 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