Database Memory & 4030/4031 (MOSC)

MOSC Banner

How to limit memory usage of oracle.exe?

edited Dec 6, 2013 5:57AM in Database Memory & 4030/4031 (MOSC) 5 commentsAnswered
We are running Oracle 11.2.0.2 enterprise edition on Windows 2008 R2.

The memory parmemters set in the following way:

memory_target        = 24000M

sga_target           = 18000M

shared_pool_size     = 4800M

db_cache_size        = 9600M

streams_pool_size    = 200M

pga_aggregate_target = 3600M

memory_max_target takes the value of memory_target as it is not set explicitly.

We hit a situation once when a poorly created SQL stmt made oracle exe use 28g of memory.

Running the following query we knew that PGA took 3 times more that was allocated:

SQL> select value/1048576 from v$pgastat where name='maximum PGA allocated';

VALUE/1048576
-------------
   9854.96973

Is there a way to limit the memory usage of oracle.exe?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center