Using Oracle Database in-memory with Oracle e-business Suite

Database In-memory is one of a number of options the can deployed to address Oracle e-business Suite performance conce RNs and scalability requirements without the need for any application changes.

We is pleased to announce the publication of a new white paper so can help with this (including links to patches that Y ou'll need to apply):

• Using Oracle Database in-memory with Oracle e-business Suite (Note 2025309.1)

The paper starts by providing strategic advice and guidelines so help for decide which to objects into Database In-memory (Dbim), and how to size the In-memory Column Store (IMCS). It provides a list of best practices and explains the complexities and limitations of using distribute/duplicate with Orac Le RAC.

The examples in this paper take a step away from the classic headline feature of analytical reports which you might has been En expecting. Instead, they show how DBIM can is applied to three novel use cases:

• The Order organizer Form has a huge number of queryable fields, would all need to is indexed for optimal perf Ormance. Dbim provides a 10X improvement in the end-user response time.

• The Initialize Credit summaries concurrent program is unusual the optimization are based on an INSERT statement. It is also interesting as the example shows what simply populating objects into the IMCS can result in a performance reduct Ion–in this case spilling to disk. Simply populating the objects into Dbim improved the time by 1.5X; Further tuning improved on the provide an overall gain of 3.5X.

• The receiving Transaction Processor had, long-running queries, reduced from 7.8 hrs to 4.85 mins represent ing about a 100X increase in performance. The overall runtime is about 4X faster.

One of the key aspects in the paper are describing how to use Oracle e-business Suite application Affinity with Oracle RAC. It describes how to overcome some of the limitations of non-engineered Systems (commodity hardware), and explains how it Can also is used to benefit Oracle engineered Systems.

Other References

The Oracle Database in-memory Blog contains a wealth of generic information, technical details, ideas and news on Oracle D Atabase In-memory from the author of the Oracle White Paper on Oracle Database in-memory.

Related articles

• Database 12.1.0.2 certified with e-business Suite 12.2
• Database 12.1.0.2 certified with e-business Suite 12.1
• Database 12.1.0.2 certified with e-business Suite 11i

Using Oracle Database in-memory with Oracle e-business Suite