Message-ID: <569b24b60958ff2434a451fd5d2ef7f23344287c.camel@cybertec.at>
Subject: Re: Linux VM Sizing
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Sam Stearns <sam.stearns@dat.com>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Cc: Joseph Miller II <joseph.miller@dat.com>, Thierno Diallo
	 <thierno.diallo@dat.com>, Peter Garza <peter.garza@dat.com>, Henry Ashu
	 <henry.ashu@dat.com>
Date: Tue, 29 Jul 2025 08:30:52 +0200
In-Reply-To: 
 <CAN6TVj=07T7ngEp9gzx6wFVb5eyVS=+Y1seupPvh0hWVXDcEGQ@mail.gmail.com>
References: 
	<CAN6TVj=07T7ngEp9gzx6wFVb5eyVS=+Y1seupPvh0hWVXDcEGQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/569b24b60958ff2434a451fd5d2ef7f23344287c.camel%40cybertec.at>
Precedence: bulk

On Mon, 2025-07-28 at 16:41 -0700, Sam Stearns wrote:
> We are sizing a Linux VM to migrate our Oracle production database to.=C2=
=A0 We are
> currently running on an Oracle Database Appliance.=C2=A0 Oracle CPU / mem=
ory usage stats are:
>=20
> CPU % usage -=C2=A025% of 20 cores / 40 threads (Intel=C2=AE Xeon=C2=AE S=
4314 processor)
> Memory % usage - 100% usage of 600G SGA
>=20
> Based on the above can anyone give advice as to how to size the CPU / mem=
ory of the Linux VM, please?

Choose something that is about as strong as the old hardware.

If you find that the old machine is too strong for the current
Oracle workload, you can also downsize.

Yours,
Laurenz Albe