CODEWITHSUNDEEP
oracle-databaseoracle10g
Angel Pizarro
Angel Pizarro

Reputation: 343

How do I limit the global memory resources of Oracle 10g database

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?

I have SGA_TARGET_MAX = 500M and a session/process limit of 150, but our max concurrent sessions have not reached above 50.

Upvotes: 3

Views: 4230

Answers (2)

Gary Myers
Gary Myers

Reputation: 35401

You don't say how much memory your machine actually has (and whether all of it is available to the Oracle instance). There are two types of memory used by Oracle. The first is the shared memory (SGA), the second is process memory (PGA). SGA is generally easier to control.

From SQL*Plus, try SHOW SGA. See if that matches your target. Also try SHOW PARAMETER PGA Then query v$process and compare the total PGA of the processes with the target. You may have set the PGA_AGGREGATE_TARGET/SGA_MAX_SIZE total too high. Or maybe Oracle can't keep the PGA memory down to the target (eg due to sessions storing lots of information in PL/SQL arrays).

Upvotes: 4

Russ Bradberry
Russ Bradberry

Reputation: 10865

try using profiles and setting the SESSIONS_PER_USER limit

Upvotes: 0

Related Questions