Migrating from Windows to Linux with Active Duplicate for standby – problem with 11.2.0.4
Recently I was working on migrating Oracle 11.2.0.4 database running on Windows, to new hardware infrastructure on Linux. This Oracle version is with us for quite a long time, plus migration from Windows to Linux is quite common (fortunately in that direction…;)), so when I…
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…
Playing with statistics modification hints
How often did you have the situation when performance problem disappeared just after refreshing object statistics? Of course it is nice to solve the problem quickly and simply, but is always better to understand what has exactly happened. Recently I had such a problem and…