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…
Oracle Home Management – part 7: Putting all together
Last part of the blog series… let’s see how to put everything together and have a single script that creates and provisions Oracle Home golden images: Review of the points The scripts will: let create a golden image based on the current Oracle Home save…
Online Statistics Gathering for ETL – Part 2
In the first part we looked at general preconditions for online statistics gathering to work and some restrictions. In this part we’ll take a look at what happens with direct path loads into partitioned tables. Partitioning There are also some points to consider while working…
Online Statistics Gathering for ETL – Part 1
Online Statistics Gathering has been introduced in 12c and is a very handy feature for ETL and batch jobs developers. However the devil is in the detail. There are some points to remember. Let’s take a closer look. Introduction If you are not familiar with…
Oracle Home Management – part 6: Simple Golden Image Blueprint
As I explained in the previous blog posts, from a manageability perspective, you should not change the patch level of a deployed Oracle Home, but rather install and patch a new Oracle Home. With the same principle, Oracle Homes deployed on different hosts should have…
New version of set_exadata_passwords.sh
A new version of set_exadata_passwords.sh is available on GitHub. With new options and a bugfix for infiniband switches.The new version is now able to change the password only on one kind of component i.e. db nodes. I wrote about a problem with chpasswd on infiniband…
chpasswd not working after upgrade
After the upgrade of a infiniband switch from version 2.1.5-1 to 2.2.6-2 my script set_exadata_passwords.sh was not working anymore. It can’t change the password of the infiniband switches because the command chpasswd threw the following error: In the blog I’ll explain why it’s not working,…
New version of check_options.sh
A new version of check_options.sh is available on GitHub. Unified Audit is now detected by the new version. It depends on kzaiang.o if it’s on and kzanang.o if off. For a more detailed description what the script does, please have a look here.
Oracle Enterprise Manager Audit
Why you should read this blog post? You need to take care of the Audit function from OEM CC even if you don’t want to use it. It’s enabled by default and needs to be managed! Housekeeping for audit Per default the audit function of…