Table of Contents
- Title and Copyright Information
- Preface
-
Changes in This Release for Oracle Sharding
-
Changes in Oracle Database 18c
-
New Features
- User-Defined Sharding Method
- Support for PDBs as Shards
- Support for Oracle GoldenGate Replication
- Centralized Diagnostics
- Multi-Shard Query Consistency Level
- Sharding Support for JSON, LOBs and Spatial Objects
- Optimizer Enhancements for Multi-Shard Queries
- Shard Replacement
- Oracle RAC Sharding
- UCP Support for Data-Dependent Routing to Oracle Sharding Middle Tiers
- Other Changes
-
New Features
-
Changes in Oracle Database 18c
- 1 Overview of Oracle Sharding
- 2 Sharded Database Schema Design
- 3 Physical Organization of a Sharded Database
- 4 Sharding Methods
- 5 Design Considerations for Sharded Database Applications
-
6
Request Routing in a Sharded Database Environment
- 6.1 Direct Routing to a Shard
-
6.2
Queries and DMLs with Proxy Routing in a Sharded Database
- 6.2.1 About Proxy Routing in a Sharded Database
- 6.2.2 Oracle Sharding Coordinator
- 6.2.3 Querying and DMLs Using Proxy Routing
- 6.2.4 Proxy Routing for Single-Shard Queries
- 6.2.5 Proxy Routing for Multi-Shard Queries
- 6.2.6 Supported Query Shapes in Proxy Routing
- 6.2.7 Execution Plans for Proxy Routing
- 6.3 Creating Affinity Between Middle-Tier Connection Pools and Shards
- 7 Shard-Level High Availability
-
8
Sharded Database Deployment
- 8.1 Introduction to Sharded Database Deployment
- 8.2 Oracle Sharding Prerequisites
- 8.3 Installing Oracle Database Software
- 8.4 Installing the Shard Director Software
- 8.5 Creating the Shard Catalog Database
- 8.6 Setting Up the Oracle Sharding Management and Routing Tier
- 8.7 Creating and Deploying a System-Managed Sharded Database
- 8.8 Creating and Deploying a User-Defined SDB
- 8.9 Creating and Deploying a Composite SDB
- 8.10 Using Transparent Data Encryption with Oracle Sharding
- 9 Migrating Data to a Sharded Database
-
10
Sharded Database Lifecycle Management
- 10.1 Managing the Sharding-Enabled Stack
- 10.2 Monitoring a Sharded Database
- 10.3 Backing Up and Recovering a Sharded Database
- 10.4 Modifying a Sharded Database Schema
- 10.5 Managing Sharded Database Software Versions
- 10.6 Shard Management
- 10.7 Chunk Management
- 10.8 Shard Director Management
- 10.9 Region Management
- 10.10 Shardspace Management
- 10.11 Shardgroup Management
- 10.12 Services Management
- 11 Troubleshooting Oracle Sharding
- Index