Our DBA's defined protocol that at least 30% memory should be reserved on server and only 70% can be allocated to database(SGA+PGA).
I have a requirement where SGA needs to increase a bit and that will be 75% of total server memory. But DBA's rejected it. I would like to understand if server really needs 30% memory when nothing else is hosted on server apart from database.
Please note that database is hosted on VM's and it's 12.1.0.1 version. Please advice what could be the best allocation of memory to database.