Using Oracle Database In-Memory with Oracle E-Business Suite
Database In-Memory is one of a number of options that can be deployed to address Oracle E-Business Suite performance concerns and scalability requirements without the need for any application changes.
We are pleased to announce the publication of a new white paper that can help with this (including links to patches that you will 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 that help you decide which objects to populate 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 Oracle RAC.
The examples in this paper take a step away from the classic headline feature of analytical reports that you might have been expecting. Instead, they show how DBIM can be applied to three novel use cases:
- The Order Organizer Form has a huge number of queryable fields that would all need to be indexed for optimal performance. DBIM provides a 10X improvement in the end-user response time.
- The Initialize Credit Summaries concurrent program is unusual the optimization is based on an INSERT statement. It is also interesting as the example shows why simply populating objects into the IMCS can result in a performance reduction – in this case spilling to disk. Simply populating the objects into DBIM improved the time by 1.5X; further tuning improved on this to provide an overall gain of 3.5X.
- The Receiving Transaction Processor had two long-running queries that reduced from 7.8 hrs to 4.85 mins representing about a 100X increase in performance. The overall runtime was about 4X faster.
One of the key aspects in the paper is 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 be 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 Database 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
最新文章
- 把包发布到npm官网
- Tomcat：基于HTTP协议的Connector配置
- 带有天气预报的高大上web报表制作分享
- iOS-UIView 之 layoutMargins & preservesSuperviewLayoutMargins 解惑
- UART总线（异步）
- .net学习之继承、里氏替换原则LSP、虚方法、多态、抽象类、Equals方法、接口、装箱拆箱、字符串
- 过期邮件替换SQL
- Shell 备忘录
- HTML基础语句
- Sqlite 错误码
- SVM（三）—Kernels(核函数)
- FreeRTOS中断优先级配置（重要）
- js格式化时间戳
- Elasticsearch学习笔记（五）索引元数据和集群元数据
- MapperFacade自动导入失败
- Data Model for Message Receiver
- C程序的编译与链接
- redis 安装报错
- ThreadPool开启多线程时支持最大连接200个(默认为2个),不加则会超时
- 31. Studio获取新的ID值方法