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 ...

Get Oracle Database 12c Performance Tuning Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.