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…

Oracle Streams is a data replication and integration feature of the Oracle database. Streams enables the propagation of data, transactions, and events it is used for data replication and integration either within the database or between two different databases. This presentation will provide an overview of the streams Architecture, will discuss the basic configuration of…

Oracle Streams is a data replication and integration feature of the Oracle database. Streams enables the propagation of data, transactions, and events it is used for data replication and integration either within the database or between two different databases. This presentation will provide an overview of the streams Architecture, will discuss the basic configuration of…

Oracle Streams is a data replication and integration feature of the Oracle database. Streams enables the propagation of data, transactions, and events it is used for data replication and integration either within the database or between two different databases. This presentation will provide an overview of the streams Architecture, will discuss the basic configuration of…

Galera is a generic replication service, providing synchronous multi-master replication. We have used Galera to implement MySQL/InnoDB cluster with features like :* high availability* client transparency* high performance, write scalabilityThe presentation will give an overview of the unique Galera replication method showing the benefits of synchronous operation. Multi-master topology can give considerable performance boost, which…

Galera is a generic replication service, providing synchronous multi-master replication. We have used Galera to implement MySQL/InnoDB cluster with features like :* high availability* client transparency* high performance, write scalabilityThe presentation will give an overview of the unique Galera replication method showing the benefits of synchronous operation. Multi-master topology can give considerable performance boost, which…

Galera is a generic replication service, providing synchronous multi-master replication. We have used Galera to implement MySQL/InnoDB cluster with features like :* high availability* client transparency* high performance, write scalabilityThe presentation will give an overview of the unique Galera replication method showing the benefits of synchronous operation. Multi-master topology can give considerable performance boost, which…

Oracle Streams is a data replication and integration feature of the Oracle database. Streams enables the propagation of data, transactions, and events it is used for data replication and integration either within the database or between two different databases. This presentation will provide an overview of the streams Architecture, will discuss the basic configuration of…

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

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