Using In-Memory 'Free' Base-Level with General Ledger Reporting in Real-Life

Abstract

This session is based on 2 cases studies of In-Memory on 19c. In-memory can be used to a limited degree without having to purchase the in-memory license. Base-level is restricted to 16Gb of in-memory store per instance. This is certainly enough to experiment with the feature before you license it, but it is more than just a try-before-you-buy option. For certain applications, depending on how they have been designed or configured this is sufficient to create a production solution that delivers significant performance improvement. 16Gb of memory might not be a lot to play with, but if you choose to store the right 16Gb you can achieve impressive results. This session will briefly describe the in-memory feature and the base-level restrictions. In this session, we will look at General Ledger reporting from a real-life Financials ERP application system. We will examine the aspects of the application and its implementation that in one case allowed base-level IM to be used effectively, and how the implementation was designed to deliver maximum effect. The result was to reduce an overnight batch reporting window from 9 hours to 6, and to reduce CPU consumption from 20 hours to 11. I will also discuss another similar system that was configure a little differently, and the results are not as clear cut.