title: How do I limit the global memory resources of Oracle 10g database
body: <p>The server I am running oracle on is suffering from out of memory errors. Anyone know if/how I can limit the global memory resources that oracle will use? </p>
  
  <p>I have SGA_TARGET_MAX = 500M and a session/process limit of 150, but our max concurrent sessions have not reached above 50.</p>