I have an instance that has been assigned 8 G of memory. From the init.ora:
No other memory parameters have been set. The database has been running since July 14th, yet AWR only shows it having allocated about 6GB of RAM to the SGA/PGA:
The Buffer Pool Advisor shows that database performance would be much better if another couple of Gigs were tacked onto it. I'm trying to think of some reason the server would decide not to (or be unable to) use the full amount of memory assigned via MEMORY_TARGET and I'm coming up blank. This is Oracle 22.214.171.124.0 Enterprise running on Solaris.