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…

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…

On the example of this real-life project, we will demonstratehow mature MySQL database software is and what an experiencedOracle DBA can expect in the MySQL land. The project included settingup highly available clustered infrastructure and disaster recoverysite for MySQL. The application was migrated to MySQL from a legacy database platform on OpenVMS.

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…

As DBAs take on more responsibility managing storage withASM they need more tools in their toolbox to help troubleshoot and managestorage over time. Often there aremisunderstandings of device files, and multiple hands touching the storagebetween multiple IT support groups. Here we will provide some information on using Linux tools to keep trackof your ASM disks…

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…

The vision for Accounts Payable is to be perceived as a business partner that adds value efficiently and cost effectively by providing accurate, timely and actionable financial data that positively impacts the bottom line. Learn how Oracle Enterprise Content Management Partner DTI provides a streamlined approach to automating the paper-intensive AP process by integrating Oracle…

The vision for Accounts Payable is to be perceived as a business partner that adds value efficiently and cost effectively by providing accurate, timely and actionable financial data that positively impacts the bottom line. Learn how Oracle Enterprise Content Management Partner DTI provides a streamlined approach to automating the paper-intensive AP process by integrating Oracle…

The vision for Accounts Payable is to be perceived as a business partner that adds value efficiently and cost effectively by providing accurate, timely and actionable financial data that positively impacts the bottom line. Learn how Oracle Enterprise Content Management Partner DTI provides a streamlined approach to automating the paper-intensive AP process by integrating Oracle…