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…

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…

Cisco and joint customers/partners, including NaviSite, will demonstrate âstateless computingâ as a cost effective alternative for running Oracle solutions while providing greater scalability, availability, and extensibility. By decoupling the utilization of physical servers, this new stateless model allows for raised service levels and simplification of management. Learn how Cisco UCS and Oracle solutions enable customers,…

How do you find very important needles in haystacks? This presentation and demo will show several use cases of Oracle Data Mining's fraud and anomaly detection capabilities. Oracle Data Mining's (ODM) Anomaly Detection algorithm trains on what is considered ânormalâ and then flags any record(s) that, on a multi-dimensional basis, appear to not fit in. Find suspicious expense report submissions, find non-compliant tax submissions, fight fraud in healthcare claims and save huge amounts of money in fraudulent claims and abuse. This presentation and demo will show several use cases of ODM's anomaly detection.

While the concept of an index is straightforward, the implementation of an Oracle indexing strategy is extremely complex. We have many types of indexing available including b-tree indexes and bitmap indexes, as well as table/index hybrids.In addition to choosing the type of index to use, we must also choose which columns to index and which…

There are too many Essbase optimization presentations with far too many tips floating around (many tips don't even work in the real world).If you come to this session, you'll hear the 10 optimization tricks that will give you 95% of the improvement to your Essbase cube. Learn how to order your dimensions, set your caches,…

Most DBAs realize that there is a lot more to Oracle backups with RMAN than "backup database;". We will present a script that can be deployed in under 15 minutes on Linux or Solaris hosts to perform disk-to-disk backups of any Oracle database 10g or newer.

This paper describes using the Oracle® Generic Connectivity gateway (OGC) to transparently integrate tables in a Microsoft SQL Server database with an Oracle database. While there are many other ways to federate data from multiple data sources, OGC offers several advantages. • OGC federation uses simple configuration files eliminating the need to write and maintain…

SQL efficiency is central to database efficiency, and the ability to interpret SQL query execution plans is a critical skill of the application developer and database administrator. In this session, we review the process of displaying and interpreting query execution plans; the meaning of operations such as "Merge Join," "Hash Join," "Hash Group By," and…

This presentation examines real-world techniques for improving the speed of SQL queries with a focus on the new Oracle11g SQL tuning features. The topics will include the new SQL workload replay, fully automatic SQL tuning, the “result cache” hint, new Oracle parameters that affect SQL performance, and changes to the new Oracle11g CBO costing approach.…