Boost your ODI jobs!
We have a lot of databases running many thousands of ODI (Oracle Data Integrator) jobs. The more jobs/sessions, the more our database holding ODI repository got saturated/busy. The CPU is starving and there are a lot of buffer gets… After we analyzed some of the busiest databases, we decided to create a couple of indexes ...