Geek Answers Handbook

Limit Oracle 10g Database Global Memory Resources

The server on which I am running oracle on suffers from memory errors. Does anyone know if I can limit the global memory resources that the oracle will use?

I have SGA_TARGET_MAX = 500M and the session / process limit is 150, but our maximum concurrent sessions did not reach more than 50.

+3
source share
2 answers

You do not say how much memory your machine actually has (and whether all this is available for an instance of Oracle). Oracle uses two types of memory. The first is shared memory (SGA), the second is process memory (PGA). SGAs are generally easier to control.

SQL * Plus SHOW SGA. , . SHOW PARAMETER PGA v $ PGA . , PGA_AGGREGATE_TARGET/SGA_MAX_SIZE. , , Oracle PGA (, - , PL/SQL).

+4

SESSIONS_PER_USER

0

More articles:


All Articles