Bloom filters and parallel execution

Today I want to share with you another interesting example of solving performance problem which happened in the database used for Business Intelligence purposes. Users were complaining that the performance in kind of staging database (STGDB) was much better than the production one (PRDDB), even though the dataset was exactly the same.

Continue reading “Bloom filters and parallel execution”

Advertisements

BI jobs performance degradation after Oracle 11.2.0.4 to 12.1.0.2 migration

If you have performance problems after migrating your BI databases from 11.2.0.4 to 12.1.0.2 or any other performance issue, you should not underestimate SQL Plan Notes, which can point you to the right direction or just let you understand what exactly is going on with your queries. Please check below how SQL Plan Notes helped me to investigate problem I recently encountered.

Continue reading “BI jobs performance degradation after Oracle 11.2.0.4 to 12.1.0.2 migration”