In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at...
In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at ODI/Database/Network level that can influence the overall load plan timings. ODI Settings 1) Check the number of parallel sessions configured against the ODI agent. Recommendation is to have NOT more than 5 ODI sessions configured to run in parallel. If your server is not sized up properly, this may have to be reduced further....
In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at ODI/Database/Network level that can influence the...
Monitor ETL Status Monitor ETL Duration Phase-wise Sample Alerts Background BIAPPS ETL or Load Plan can be monitored from ODI clients or BIACM. However what if...
Monitor ETL Status Monitor ETL Duration Phase-wise Sample Alerts Background BIAPPS ETL or Load Plan can be monitored from ODI clients or BIACM. However what if you wanted to automate the monitoring? Is there a way to detect ETL is running? Is there a way to be notified if a particular ETL phase (like SDE/SIL/PLP) is taking longer than expected? This blog shows how it is possible using the latest BIAPPS Version 11.1.1.10.2 and Oracle Database Enterprise Manager (OEM),that...
Monitor ETL Status Monitor ETL Duration Phase-wise Sample Alerts Background BIAPPS ETL or Load Plan can be monitored from ODI clients or BIACM. However what if you wanted to automate the monitoring?...
Authors: Patrick Block, Principal Member Technical Staff, Oracle BI Apps Development Simon Miller, Director OBIA, Oracle Customer Engineering and Advocacy Lab...
Authors: Patrick Block, Principal Member Technical Staff, Oracle BI Apps Development Simon Miller, Director OBIA, Oracle Customer Engineering and Advocacy Lab (CEAL team) Support for table partitioning was introduced to the BI Applications 11.x release series starting with version 11.1.1.8.1. Partitioning support is largely automated - define the partitions on the fact table directly in the database, and then the BI Apps Fact Table IKMs and the Oracle database does the work....
Authors: Patrick Block, Principal Member Technical Staff, Oracle BI Apps Development Simon Miller, Director OBIA, Oracle Customer Engineering and Advocacy Lab (CEAL team) Support for...
Authors: Simon Miller, Director OBIA, Oracle Customer Engineering and Advocacy Lab (CEAL team) and Patrick Block, Principal, OBIA Development In an earlier blog...
Authors: Simon Miller, Director OBIA, Oracle Customer Engineering and Advocacy Lab (CEAL team) and Patrick Block, Principal, OBIA Development In an earlier blog post 3 Modes for Moving Data to the BI Applications DW from a Source Application Database the available options for setting up data source connections was provided in detail, along with screenshots. It should be noted this information written for OBIA 11.1.1.7.1 is still applicable for 11.1.1.8.1. While not all...
Authors: Simon Miller, Director OBIA, Oracle Customer Engineering and Advocacy Lab (CEAL team) and Patrick Block, Principal, OBIA Development In an earlier blog post 3 Modes for Moving Data to the BI...