Re: Total size of shared memory used on a server by several Oracle instances

From: Bib Endum <gd-newsgroups_at_spamex.com>
Date: Thu, 26 Feb 2004 09:32:06 -0500
Message-ID: <Jrn%b.17243$253.1076314@news20.bellglobal.com>

"rjp" <rjp.l_at_laposte.net> a écrit dans le message de news:9b7a7215.0402260408.d531dbf_at_posting.google.com...
> Hi,
>
> I need to determine what amount of server shared memory I need on a
> server with several Oracle instances ?
> Does I simply have to sum the total sga size of all instances or is a
> more complicated ?
>

I would think that you are right, if you want to know the amount of shared memory. By total sga size I assume you include db buffers, redo buffers, shared pool, etc...

If you want to determine the total amount of ram used, that would be a lot more complicated, depending of the number of processes you have, what they are doing, and how they are configured. Received on Thu Feb 26 2004 - 08:32:06 CST