A customer having a DWH has a View with a huge number of Left Outer Joins to a dim table. The Reports using this view will only using a small number of columns of some dim tables. But theLesen Sie weiter »
My friend Bernhard explains to me his issue using incremental gather_table_stats on a large partitioned table in a DWH. This table has only changes on a few partitions per day, normally the last two. I was looking for a solution …Lesen Sie weiter »
This week a colleaque asked me for help while droping a table column. Inside of a PL/SQL procedure a table column has to be droped to prepare the table for an partition exchange. But while execute the partition exchange theLesen Sie weiter »
Christian Antognini descibed in his book Troubleshooting Oracle Performance how to gather the system statistics in a very proficient way. The main idea of gathering system stats is to collect the system stats inLesen Sie weiter »
As described in my previous article Cloning the Node two a 2-Node-RAC we can start to install the GI software on both nodes. Normally you can install and configure the Grid Infrastructure (GI) Software on both nodes, starting on one …Lesen Sie weiter »
In my previous article Adding ASM Disks and Configuration of OS I described to add some ASM Disks and to configure the Oracle Enterprise Linux (OEL) 7.2 to be ready for Oracle RAC 12c. In this article I will describe …Lesen Sie weiter »
In addition to my first article Installation of OEL 7.2 I will show you how to add some ASM Disks and to configure the Oracle Enterprise Linux (OEL) 7.2 to be ready for oracle RAC 12c on OEL 7.2Lesen Sie weiter »
In diesem Blog werde ich verschiedene Fallstudien, Beispiele, HowTos und Erfahrungen aus dem täglichen Arbeiten in verschiedenen Projekten bei unterschiedlichen Kunden berichten.
Ich werde versuchen, soweit es irgend geht und sinnvoll ist, die Beispiele so zu „entfremden“, dass diese auf keinen Kunden hindeuten. Sollte dies dennoch der Fall sein, so bitte ich um kurze Information oder E-Mail, damit ich diese verbessern oder den Artikel komplett entfernen kann.