Gathering Statistics in the Autonomous Data Warehouse Cloud
Optimizer statistics are essential for good execution plans and fast performance of the SQL queries. Of course, this is also the case in the Autonomous Data Warehouse Cloud. But the handling of gathering statistics is slightly different from what we know from other Oracle databases….
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…
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…
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…
Social Media @trivadis