Oracle Sharding for the 99%


Oracle promotes Sharding as a solution for running massive workloads at scale, but Sharding addresses a surprising number of issues the “other 99%” of us face—matters of compliance, performance and availability. Join me to discover what Sharding is and how “the rest of us” can use it, too! Description Oracle Sharding is a technology for managing multiple, geographically dispersed databases in a shared-nothing architecture. Though associated with large, complex databases processing billions of daily transactions or petabytes of data, Sharding has features and capabilities needed by the “other” 99% of databases, too. Organizations with data subject to tenancy and sovereignty regulations; mandates to limit latency and response times; free/paid or multi-tiered delivery models; and those seeking extreme availability and fault isolation are all candidates for Sharding. Learn how Oracle’s sharding technology works, its limits, implementation planning and use cases, as well as the features and enhancements introduced in Oracle 20c that make sharding an easier and more compelling solution. Session attendees will:

* Develop an understanding of Oracle Sharding and its place in within Oracle’s MAA roadmap

* Recognize use cases for Oracle Sharding and how they apply in different environments

* Discover the limitations of the features and technology

* Explore new features in Oracle 20c that make sharding easier and more accessible

* Learn how to install and experiment with a sharded database.