Criteria for CPU core sizing when migrating Oracle DBs from SPARC/Solaris to Linux
Hi all,
I'm planning a migration of several Oracle 19c CDB instances from SPARC/Solaris (with LDOMs) to Linux (Red Hat 8/9) and am trying to determine the right number of physical CPU cores for the new servers.
I have 30-day AWR data available (CPU usage, AAS, wait events, I/O). My question is: what are the key indicators or rules you use to derive the required core count from AWR data?
Any real-world experience or methodology appreciated.
Thanks