O'Reilly logo

Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance by Joyjeet Banerjee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required