You should take care about statistics!

18. April 2020 Uncategorized 0
Ever since Oracle introduced the CBO (Cost Based Optimizer) there were some performance issues, mostly because of missing or staled statistics in the database. I stopped to count the cases, when I just gathered fresh statistics for some table(s) and voilà – the query runs 100x faster! I will mention just one of the latest ...

Boost your ODI jobs!

15. September 2014 Uncategorized 0
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 ...