RE: Probably stupid question about sum of SGA sizes on NT server...

Paul,

This depends on the performance impact you are ready to endure on the instances. You can in fact extend your memory to larger than the total of 256Mb, but "swapping" memory from physical to "virtual" can cause some pretty poor performance.

There are other things you also need to take in to account. NT requires a fair chunk of this memory simply to run the O/S, and any other services that may be running in background.

I would certainly not even CONSIDER totalling all of the SGA memory, and the memory required by the NT O/S to more than the total of your physical and virtual (page file) memory. I *think* that the page file should be/usually is around 1.5 * physical memory, though you can in fact increase this through Control Panel/System if you want to.

The question arises though - Why not increase memory? You can buy 256Mb of memory comercially in the shops now for around £80..

HTH Mark

-----Original Message-----
Vincent
Sent: Thursday, June 21, 2001 01:26
To: Multiple recipients of list ORACLE-L

Hi folks,

as the subject indicates, I feel really stupid asking this question, but here goes...

If I have several Oracle 8i instances running on an NT Server with, say, 256Mb of memory available, then does this mean that the sum of the SGA sizes for all the instances, taken together, can't exceed 256Mb? As I say, it feels like a stupid question, but the phrase "virtual memory" keeps popping into my head!

Paul

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Vincent
  INET: Paul.Vincent_at_uce.ac.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).