Cheers Stefan - I suppose the payoff between 64K/16M pages is the additional
interaction needed with the Unix team when adjusting SGA's for (potentially)
minimal benefit. Good point about the shape of the application. I've not seen
any tangible benefit using SLOB with 16M pages, but I think I may need to
adjust the amount of SGA being used during benchmarking to see any benefit fr
the larger pages.
I suppose the kicker with SMT2/4/8 is the amount of CPU's generally active v
the peak load (and will the peak load still be that peaky given the faster
CPU's). Think I may have to revisit my benchmarking for the P9's that have just
been delivered.
Good links - I'd not seen a couple of them previously in my googling.
Neil.
________________________________
From: Stefan Koehler <contact@xxxxxxxx>
Sent: 25 October 2019 12:17
To: neil_chandler@xxxxxxxxxxx <neil_chandler@xxxxxxxxxxx>;
Oracle-L@xxxxxxxxxxxxx <Oracle-L@xxxxxxxxxxxxx>
Subject: Re: AIX Large Pages and SMT4
Hello Neil,
Does anyone have any input on whether to use medium pages or large pages on
AIX in relation to performance?
Does anyone have any input about using SMT2/4/8 usage - my slob testing has
seen slightly better throughput with SMT4 over SMT2 (SMT4 vs SMT8 was the
same)
Neil Chandler <neil_chandler@xxxxxxxxxxx> hat am 24. Oktober 2019 um 10:48
geschrieben:
Hi,
A couple of Oracle (11.2.0.4 and 19) on AIX (7.2) questions:
Does anyone have any input on whether to use medium pages or large pages on
AIX in relation to performance? I'm primarily concerned about performance -
especially when the server is stressed.
Does anyone have any input about using SMT2/4/8 usage - my slob testing has
seen slightly better throughput with SMT4 over SMT2 (SMT4 vs SMT8 was the
same) but my testing has been limited to this point and is far from
conclusive.
Neil Chandler.