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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
