DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle.exe ran out of memory on Windows 2000

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    Oracle.exe ran out of memory on Windows 2000

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Just a thought, what is your sort_area_size and sort_area_retained_size? Is it possible that someone is running a long query and sucking up memory due to an in memory sort? If a user logging out of Oracle causes the memory problem to go away, then it would be a problm with the settings of your pga. However, it could also be a process using memory unrelated to Oracle.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width