Hello!
I have a customer currently running Oracle Database 11g Standard Edition Release 11.2.0.4.0 64-bit on Oracle Linux 7.6 on physical hosts with multi-threaded CPUs. They are aware of the situation with the support for 11g and wish to upgrade to 18c or 19c imminently. However, they are aware of the 16 CPU thread limit imposed by SE2's licensing and wish therefore to test performance of their 11g databases under the SE2 CPU thread limit.
On a test VM with 4 vCPUs I have tried setting a test database's CPU_COUNT parameter to 2 and then starting 20 SQL*Plus sessions using the following code to induce load on the CPUs:
(
TWO_TASK=//VMORACLE/db11g sqlplus sys/******** as sysdba <<END
alter session set plsql_optimize_level=0;
exec loop null; end loop;
END
)&
However, this test proved inconclusive as 'top' showed that all 4 CPUs were being used.
How can the customer limit their current 11g databases to SE2's 16 CPU thread limit so they can evaluate performance of their databases and be reasonably certain of the expected performance (with regard to CPU usage) when they come to upgrade to 18c or 19c?
Many thanks in anticipation...
Neil Garside