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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
