Images

CHAPTER5

Database In-Memory Advisor

With more than a few thousand objects in your database, it sometimes becomes very confusing to determine what to keep in memory. The In-Memory Advisor can help by evaluating your workload and job patterns over a period of time and recommending how much benefit you will get by keeping certain objects in memory. The In-Memory Advisor looks at the various metrics obtained from Automated Workload Repository (AWR) reports, SQL plan cardinalities, and the Active Session History (ASH).

The tool also takes the following factors into account to estimate the gains:

   Object statistics

   Compression factor (compression ...

Get Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance now with O’Reilly online learning.

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