Quest Forum Digital Event 2020
First introduced in 12cR2, 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 the considerations of choosing the sharding method in a global geographic distribution application and some experience of using the Sharding Advisor tool. 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.