Achieving Extreme Scalability &Total Fault Isolation with Oracle Sharding

Oracle Sharding was further improved in 18c/19c for linear scalability and complete fault isolation of OLTP workloads. With Oracle sharding Data are partitioned horizontally partitioned across discrete Oracle Databases (shards) in shared-nothing architecture that collectively form a single logical database. Come to this session to learn its latest improvements in Oracle 19c and 20c, sharding on database cloud(DBCS) and leveraging sharding for your business. We will share the experience and tips of configuring sharded database architecture with HA replication for massive scalability and complete fault isolation. We will also discuss some of considerations of choosing sharding method in a global geographic distribution application and the experience of using Sharing Advisor . We will also discuss some new sharding features that are coming in Oracle 20c such as Federated Sharding and sharding with database in Persistent memory.

Oracle Sharding was further improved in 18c/19c for linear scalability and complete fault isolation of OLTP workloads. With Oracle sharding Data are partitioned horizontally partitioned across discrete Oracle Databases (shards) in shared-nothing architecture that collectively form a single logical database. Come to this session to learn its latest improvements in Oracle 19c and 20c, sharding on database cloud(DBCS) and leveraging sharding for your business. We will share the experience and tips of configuring sharded database architecture with HA replication for massive scalability and complete fault isolation. We will also discuss some of considerations of choosing sharding method in a global geographic distribution application and the experience of using Sharing Advisor . We will also discuss some new sharding features that are coming in Oracle 20c such as Federated Sharding and sharding with database in Persistent memory.