Ridurre le attese su una tabella in fase di inserimento massivo nell’ipotesi che questo venga effettuato da un numero elevato di processi paralleli generando una contention a livello di accesso alla tabella stessa e agli oggetti ad essa correlati.
Per saperne di più* This page is the English translation of the original Italian blog post I wrote in the ICTeam blog Recently I had to analyze an Oracle DB that showed high elapsed times on some SQL statements that “under normal...
Per saperne di più* This page is the English translation of the original Italian blog post I wrote in the ICTeam blog In this post I describe a problem with a query executed in PARALLEL mode on an Exadata version 12.2 using a compressed...
Per saperne di più* This page is the English translation of the original Italian blog post I wrote in the ICTeam blog I recently encountered a strange behavior of the Oracle optimizer on a MERGE SQL statement. The problem The average...
Per saperne di più
* This page is the English translation of the original Italian blog post I wrote in the ICTeam...
Per saperne di più
Commenti recenti