Oracle DB using more memory then memory_max_target
Hi
I have some strange behavior of the DB memory usage.
This is configured:
memery_max_target 102G memory_target 51G sga_target 0 sga_max_size 41G pga_aggregate_limit 0 pga_aggregate_target 0
But …
SQL> SELECT SUM(value) / power (1024,3) FROM V$SGA; SUM(VALUE)/POWER(1024,3) ------------------------ 40.2499992 SQL> SELECT SUM(PGA_ALLOC_MEM) / power (1024,3) FROM V$PROCESS; SUM(PGA_ALLOC_MEM)/POWER(1024,3) -------------------------------- 113.820047
This is in total 152GB, more then the configured 102GB.
What do I miss here?
Thanks in advance.
Regards,
Sergej
0