Overview:
Oracle Autonomous Database comes with preconfigured database services like, HIGH, MEDIUM, LOW etc. These services control the priority of the sessions when the system is under resource pressure and some extent control the parallel degree used. Out-of-the-box, Oracle Business Intelligence Applications 11.1.1.10.3 Patch Set 3 support ONLY Oracle Autonomous Database (ADB) preconfigured database service “LOW”. However, if you would want to use other preconfigured database services other than “LOW” for a specific OBIA load plan scenario / group of OBIA load plan scenarios then this article would provide you an overview on how to implement & configure OBIA load plan scenario to use various Oracle ADB preconfigured database service while OBIA Load plan execution takes place.
Limitations:
- Implementation steps ONLY applicable for OBIA 11.1.1.10.3 Patch Set 3 Release.
Prerequisites :
- Implementation of this solution should be treated as customization solution.
- OBIA Target warehouse schema must be deployed on Oracle Autonomous Database as per the OBIA 11.1.1.10.3 Patch Set 3 certification matrix.
- To understand more about Oracle ADB Preconfigured database services, refer to the Oracle Autonomous Database Documentation.
Benefits:
- There can be a significant performance improvement.
- Customers can leverage HIGH or MEDIUM services features provided by Oracle Autonomous Database based on the need bases during OBIA Product implementation.
How to Implement:
- Download here the technical implementation document.
Disclaimer:
- Implementation steps provided in this blog are NOT supported by Oracle and should be treated as customization.