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:
Compression factor (compression ...