We just had a situation where the Oracle.exe memory usage peaked at 1.5Gb and no other users could log onto the database, including DBAs to investigate. (the server has 2Gb of memory)

The problem is now resolved as the 'process/resource' must have logged off, and the oracle.exe went back to 300Mb (which it normally is).

Questions: Is the SGA a set size? (our SGA is 270Mb)? Is the PGA causing this problem? How do we limit the PGA/thread memory? How do we monitor the Thread memory on Windows? Can this happen on Unix?

We are running 8i on Windows 2000. Thanks.