Hello!
We have a big honking physical machine running Oracle Linux to 7.9 as well as the database 19.0.0.0.0. The DBA does not want to update either of those. However the box is running with 32 cores at about 25% utilization and 3 TB (!!!!!) of RAM that is mostly being wasted. 2.25 TB is not being used and the biggest user is a 520 GB Disk Cache. The OS seems to use around 135 GB of RAM most days with a previous max of around 192 GB.
We want to move to a brand new, high speed Hyperflex VMWare stack, with a dedicated pair of hosts for DB loads. The problem is they want the same specs. I think they could get by with 8 or 12 vPUs and maybe 192 GB of RAM.
Is that reasonable? I am a system admin, not a dba so I have no idea what hey need. And is a disk cache of 520 GB (when all the disks combined are less then 1 TB) really needed when moving to a system that uses all SSD? Is it needed at all and if so, at what level?
Thanks for any help and please place this in whatever category it should be if I got it placed wrong.
-Roger