How to limit memory usage of oracle.exe?
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?