Skip to main content

Posts Tagged ‘Load Plan’

How to Create Gather Statistics Procedure in ODI

Gathering Statistics of a database schema before executing an ODI load plan will improve performance by helping the Optimizer to select optimal execution plan by referring to latest statistics, instead of stale statistics. We can gather statistics of Oracle database schema at a scheduled time of day using the DBMS_SCHEDULER and DBMS_AUTO_TASK_ADMIN packages, However, if […]

Creating Oracle Data Integrator (ODI) Scenario and Load Plan

Hopefully everyone has been enjoying my many post on Oracle Data Integrator (ODI), again its starting to become one of my favorite ETL or E-LT software solutions.  With that being said, I wanted to continue my discussions with ODI and create a post showing you all how to create a ODI scenario and load plan. […]