Nach Markierungen suchen

Star Schema Optimization in Autonomous Data Warehouse Cloud

Oracle Autonomous Data Warehouse Cloud does not allow to create indexes. Is this a problem for star schemas because no Star Transformation can be used? Or are the required bitmap indexes automatically created? A look under the hood of ADWC. … Continue...

Veröffentlicht 13 Sep 2018 18:03 von triBLOG

Gespeichert unter: Oracle, Cloud, Performance, in-memory, Dimensional Modeling, ADWC

10 Tips to Improve ETL Performance – Revised for ADWC

The Autonomous Data Warehouse Cloud (ADWC) is a self-configuring, fast, secure and scalable platform for data warehouses. Does this mean we don’t have to take care anymore about performance of our ETL processes? Which performance tips are still important...

Veröffentlicht 20 Jul 2018 15:29 von triBLOG

Gespeichert unter: SQL, Oracle, Cloud, Performance, ETL, ADWC

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 …...

Veröffentlicht 11 Jul 2018 17:46 von triBLOG

Gespeichert unter: Oracle, Cloud, Performance, ETL, ADWC

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...

Veröffentlicht 5 Jul 2018 15:10 von triBLOG

Gespeichert unter: Oracle, Troubleshooting, Performance, optimizer, statistics, Parallel Processing, dynamic sampling, parsing, bloom filter

Adaptive Plans at Kscope Community Service Day

Since Oracle 12c, the query optimizer is able to change execution plans at runtime. This feature is called “Adaptive Plans”. Something similar happened on the ODTUG Community Service Day at the Kscope conference in Orlando. The ODTUG Community Service...

Veröffentlicht 14 Jun 2018 22:51 von triBLOG

Gespeichert unter: Oracle, Performance, conferences, Oracle 12c

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...

Veröffentlicht 7 Jun 2018 9:00 von triBLOG

Gespeichert unter: Oracle, Performance, hints, optimizer, statistics, execution plan

10: Office 365 Performance

Wenn wir über Office 365 Performance reden, sollten wir die folgenden Punkte beachten: SharePoint on-premise vs. Online Bandbreite CDN (Content Delivery Network) UI, ggf. eigene Lösungen, Masterpage Mit Browser Developer Tools analysieren Große Listen...

Veröffentlicht 18 Mai 2018 11:08 von SharePoint und Office 365 Blog

Gespeichert unter: Office 365, podcast, Performance

Using Temporary Tables for Complex Reports

Global temporary tables (or private temporary tables, if you use Oracle 18c) are a practical feature to be used for SQL queries with multiple steps, for example complex reports in a data warehouse. If you want to use them, some … Continue reading...

Veröffentlicht 15 Mai 2018 23:40 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, DWH Architecture

Azure App mit PremiumV2 App Plan klonen

In Microsoft Azure gibt es den neuen App Plan PremiumV2. Neuste Funktionen sind vor allem bessere Performance der aktuellen CPU Generation, sowie SSD Speicher – yeah. Hört sich vielversprechend an, also gleich mal ausprobieren. Doch die erste Hürde...

Veröffentlicht 20 Apr 2018 8:33 von SharePoint und Office 365 Blog

Gespeichert unter: PowerShell, Azure, Skalierung, Performance, Azure Cloud Shell, App Service, Scale up, Klonen, App Service Plan, Resource Group

Keep Your SQL Simple (and Fast)

Complex SQL statements are hard to understand – not only for us, but for the query optimizer, too. Sometimes, it is a good idea to write a simpler SQL query to do the same work. Here a nice story about … Continue reading →...( read more...

Veröffentlicht 3 Apr 2018 22:01 von triBLOG

Gespeichert unter: SQL, Oracle, Performance

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...

Veröffentlicht 26 Mrz 2018 6:30 von triBLOG

Gespeichert unter: Migration, Oracle, Performance, optimizer, Parallel Processing, execution plan

3: IOPS, das A und O jeder Datenbank

Performance IOPS / Input Output per Second Spindel, Drehzahl, Zugriffszeiten, SSD RAID Datenbanken SQL on-premise Azure SQL und Elastic Database / DTU MySQL on Azure Standard Speicherplatz kommt automatisch Berechnung Bei jedem Server, der eine SQL Server...

Veröffentlicht 23 Mrz 2018 21:25 von SharePoint und Office 365 Blog

Gespeichert unter: SharePoint, Azure, Infrastruktur, podcast, Performance, IOPS

SQL: TempDB Dateien verschieben

Heute ein kleiner aber feiner Beitrag am Rand von SQL Optimierung. Grundsätzlich sollten die Datenbankdateien der TempDB ja auf einer eigenen Disk liegen. Wenn dies erst nach der Installation von SQL hinzugefügt wird, oder aber beim hinzufügen zusätzlicher...

Veröffentlicht 2 Mrz 2018 9:25 von SharePoint und Office 365 Blog

Gespeichert unter: SQL, Infrastruktur, Konfiguration, Setup, Performance

BP and Patch 22652097: set optimizer_adaptive_statistics to FALSE explicitly or it might not work!

According to Nigel’s blog post: The Oracle 12.1.0.2 October 2017 BP and the Adaptive Optimizer if you installled the patch 22652097 prior to apply the Bundle Patch 171018, the BP apply in the database should recognize that the patch was …...

Veröffentlicht 20 Feb 2018 17:26 von triBLOG

Gespeichert unter: Performance, Oracle Database 12c, Trivadis Blog

Direct-Path INSERT and NOLOGGING with Oracle 12.2

Direct-Path INSERT is a very efficient way to load data into data warehouse tables. The load performance can even be improved with NOLOGGING on the target table. In Oracle 12c Release 2, this is even possible for Oracle Data Guard … Continue reading...

Veröffentlicht 20 Feb 2018 10:49 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, Oracle 12c

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives