We are sizing a Linux VM to migrate our Oracle production database to. We are currently running on an Oracle Database Appliance. Oracle CPU / memory usage stats are:
CPU % usage - 25% of 20 cores / 40 threads (Intel® Xeon® S4314 processor)
Memory % usage - 100% usage of 600G SGA
Linux uses all available cache; is Oracle different? (IOW, would it also use 100% of 800GB?)
Based on the above can anyone give advice as to how to size the CPU / memory of the Linux VM, please?
Our 8TB Oracle DB was 6TB when migrated to PG 12 (this was a while ago) and the AWS RDS Postgresql instance (which was spec'd -- before I got to the project -- the same as the on-prem Linux server since the Oracle server ran 60-70%) was constantly less 10% of capacity in CPU and RAM.
