Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 7 Vote(s) - 3.57 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle E-Business Suite and using Oracle Database In-Memory
08-07-2015, 10:34 PM,
Oracle E-Business Suite and using Oracle Database In-Memory
Latest announcement in the month of August 2015 through Steven Chan Blog By Steven Chan - EBS-Oracle on Aug 05, 2015
Authors: Andy Tremayne and Deepak Bhatnagar, Oracle Development
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): 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.
[Image: dbim.png]
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
Thanks given by:

Possibly Related Threads…
Thread Author Replies Views Last Post
  Oracle Fusion Financials Online Training admin 0 6,369 06-02-2017, 09:31 AM
Last Post: admin
  Oracle E-Business Suite 12.2.6 released admin 0 6,575 10-08-2016, 05:46 AM
Last Post: admin
  Download Now: Oracle OpenWorld Presentations admin 0 6,205 11-13-2015, 10:38 PM
Last Post: admin
  Oracle E-Business Suite certified with Access Manager admin 0 6,514 07-20-2015, 09:29 PM
Last Post: admin
  E-Business Suite certified with Oracle Internet Directory 11gR1 admin 0 6,581 07-20-2015, 09:26 PM
Last Post: admin
  E-Business Suite Plug-in for Enterprise Manager 12c released admin 0 6,449 06-07-2015, 10:48 PM
Last Post: admin
  Oracle released VirtualBox 5.0 Candidate 1 released admin 0 5,623 06-03-2015, 07:42 PM
Last Post: admin
  Oracle Linux 7.1 is released admin 0 5,922 04-27-2015, 08:24 PM
Last Post: admin
  EBS 12.1 certified with Oracle Database on HP-UX Itanium, IBM AIX admin 0 2,474 03-28-2015, 10:20 PM
Last Post: admin
  E-Business Suite 11i Certified with Database admin 0 2,383 02-14-2015, 07:23 AM
Last Post: admin

Users browsing this thread: 1 Guest(s)
Open Tech Talks Get Oracle Tutorials, Tips! Post a Question!