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 […]
Posts Tagged ‘Load Plan’
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. […]