RE: NT -> Win2K causes performance degradation..

Interesting.

We noticed the same thing on Windows2000, it doesn't get mentioned often. Does it mean not many people maintain databases that require more than 1.5G of memory on their Windows servers?

My impression so far:
- one can't use virtual memory on the Windows platform for a busy database,
including user connections, possibly because the SGA memory areas are accessed frequently, more frequently than the Virtual Memory Manager can handle.
- on a 4G server, windows only provides us with 1.5G or so of memory for
programs.

I have been wondering whether this might be why Oracle didn't produce a Windows version of the Collaboration Suite for v2, and haven't re-introduced one for the current version either: resource allocation problems on the Windows OS. For v2 they said they planned to release one, but never did as far as I know.

If you run (say) Red Hat Advanced Server on a 4G server, how much memory is available for the Oracle software? Is it closer to 1.5G or to 4G?

Just curious whether some shops have switched OS on the same hardware, and noticed a difference in the amount of available resources on the server.

I don't know whether Windows2003 resolves this resource allocation problem, I would be curious to learn that too.

My focus is not the Collaboration Suite per se, just the resource allocation limit on Win2k.

Patrice.

-----Original Message-----
[mailto:Murali_Pavuloori/Claritas_at_claritas.com] Sent: December 16, 2003 6:04 PM
To: Multiple recipients of list ORACLE-L

We run oracle 9.2.0.3 on Win 2000 and have observed that whenever the memory on ora.exe process reaches around 1.4G, our application runs into "Listener unable to start a dedicated server process" At this point no one will be able to connect to the db and we are forced to restart.

We are exploring to migrate the db on to Win 2003.

Murali.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).