Optimizing Instance Memory
Optimizing the memory you allocate to an Oracle database is one of the most critical tasks you need to perform as a DBA. Over the years, Oracle DBAs were used to spending vast amounts of their time analyzing memory usage by the database and trying to come up with the best possible allocation of memory. Since the Oracle Database 11g release, you can let Oracle manage memory allocation to your database by taking advantage of Oracle’s automatic memory management feature, so you can leave the database to optimize memory usage while you focus on more important matters.
This chapter starts by explaining how to set ...