Tag: Database

Most storage systems employ B-tree data structures, and suffer from the performance cliffs and unpredictable run times of B-trees. This talk explains how the Fractal Tree data structures work and why they can provide dramatically improved performance in both theory and in practice, yielding 30-fold to 100-fold speedups for trickle loading data while maintaining indexes.…

Of all the Oracle wait events, the buffer busy wait and read by other session are two of the most intriguing. While Oracle never officially locks a buffer, during high concurrency situations buffers can become too busy to access. A methodical step-by-step diagnosis and a solid grasp of the relevant Oracle internals is particularly important…

Of all the Oracle wait events, the buffer busy wait and read by other session are two of the most intriguing. While Oracle never officially locks a buffer, during high concurrency situations buffers can become too busy to access. A methodical step-by-step diagnosis and a solid grasp of the relevant Oracle internals is particularly important…

Of all the Oracle wait events, the buffer busy wait and read by other session are two of the most intriguing. While Oracle never officially locks a buffer, during high concurrency situations buffers can become too busy to access. A methodical step-by-step diagnosis and a solid grasp of the relevant Oracle internals is particularly important…

Effective performance management and diagnosis necessitates collection of sufficient database statistics and timely analysis. Oracle provides AWR to collect statistics over desired period of time. It also provides ADDM to perform analysis of AWR. However, often AWR data is so huge that finding a sub-optimal SQL and bottleneck is like finding a needle in the…

Effective performance management and diagnosis necessitates collection of sufficient database statistics and timely analysis. Oracle provides AWR to collect statistics over desired period of time. It also provides ADDM to perform analysis of AWR. However, often AWR data is so huge that finding a sub-optimal SQL and bottleneck is like finding a needle in the…

Effective performance management and diagnosis necessitates collection of sufficient database statistics and timely analysis. Oracle provides AWR to collect statistics over desired period of time. It also provides ADDM to perform analysis of AWR. However, often AWR data is so huge that finding a sub-optimal SQL and bottleneck is like finding a needle in the…

Of all the Oracle wait events, the buffer busy wait and read by other session are two of the most intriguing. While Oracle never officially locks a buffer, during high concurrency situations buffers can become too busy to access. A methodical step-by-step diagnosis and a solid grasp of the relevant Oracle internals is particularly important…

As the part of IOUG High Availability bootcamp, these two half hour HA expert panel will offer you the opportunities to interact with the experts on various topics on HA. Come to join these two panels by bringing your own questions to the industry experts on the panel and get some answers from them.

As the part of IOUG High Availability bootcamp, these two half hour HA expert panel will offer you the opportunities to interact with the experts on various topics on HA. Come to join these two panels by bringing your own questions to the industry experts on the panel and get some answers from them.