Our database is slow in some very important use cases. I have traced it to a problem with some queries performing full text searches and single row accesses on a lot of records (db file sequential read) afterwards. Once the data is in memory, those queries become very fast.
The solution from us developers is now to put the hottest table into memory.
We currently have a SGA_MAX of 20 GB, SGA_TARGET is 14GB. ADDM and AWR recommend 25GB of SGA space.
Our infrastructure team will now upgrade our database to 40GB, however, the database admin sais that that much ram can kill oracle performance.
Is that true? I cannot possibly imagine that 20GB more RAM will make the database go slower.
Version: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production