Database Memory & 4030/4031 (MOSC)

MOSC Banner

Oracle DB using more memory then memory_max_target

edited Mar 14, 2025 3:31PM in Database Memory & 4030/4031 (MOSC) 3 commentsAnswered ✓

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

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