Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Sharding
-
1
Oracle Sharding Overview
- What is Sharding
- About Oracle Sharding
- Oracle Sharding as Distributed Partitioning
- Benefits of Oracle Sharding
- Example Applications using Database Sharding
- Flexible Deployment Models
- High Availability in Oracle Sharding
- Sharding Methods
- Client Request Routing
- Query Execution
- High Speed Data Ingest
- Deployment Automation
- Data Pump Migration
- Lifecycle Management of Shards
-
2
Oracle Sharding Architecture and
Concepts
- Components of the Oracle Sharding Architecture
- Partitions, Tablespaces, and Chunks
- Tablespace Sets
- Sharding Methods
- Sharded Database Schema Objects
- Shard-Level High Availability
- Query Processing and the Query Coordinator
- Client Application Request Routing
- Management Interfaces for a Sharded Database
-
3
Sharded Database Deployment
- Introduction to Sharded Database Deployment
- Provision and Configure Hosts and Operating Systems
- Install the Oracle Database Software
- Install the Shard Director Software
- Create the Shard Catalog Database
- Create the Shard Databases
- Configure the Sharded Database Topology
- Deploy the Sharding Configuration
- Create and Start Global Database Services
- Verify Shard Status
- Example Sharded Database Deployment
- Using Transparent Data Encryption with Oracle Sharding
- 4 Sharded Database Deployment with Kubernetes, Terraform, and Docker
-
5
Sharded Database Schema
Design
- Sharded Database Schema Design Considerations
- Choosing Sharding Keys
- Primary Key and Foreign Key Constraints
- Indexes on Sharded Tables
- DDL Execution in a Sharded Database
- PL/SQL Procedure Execution in a Sharded Database
- Creating Sharded Database Schema Objects
- Schema Creation Examples
- Monitor DDL Execution and Verify Object Creation
- DDL Execution Failure and Recovery Examples
- Generating Unique Sequence Numbers Across Shards
- 6 Migrating to a Sharded Database
-
7
Query and DML Execution
- How Database Requests are Routed to the Shards
- Connecting to the Query Coordinator
- Query Coordinator Operation
- Query Processing for Single-Shard Queries
- Query Processing for Multi-Shard Queries
- Supported Query Constructs and Example Query Shapes
- Supported DMLs and Examples
- Gathering Optimizer Statistics on Sharded Tables
- 8 Developing Applications for the Sharded Database
-
9
Sharded Database Administration
- Managing the Sharding-Enabled Stack
- Managing Oracle Sharding Database Users
- Monitoring a Sharded Database
- Backing Up and Recovering a Sharded Database
- Modifying a Sharded Database Schema
- Propagation of Parameter Settings Across Shards
- Migrating a Non-PDB Shard to a PDB
- Managing Sharded Database Software Versions
- Shard Management
- Chunk Management
- Shard Director Management
- Region Management
- Shardspace Management
- Shardgroup Management
- Services Management
- 10 Troubleshooting Oracle Sharding
- 11 Oracle Sharding Reference