Table of Contents
- Title and Copyright Information
- Preface
-
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 Migration
- Lifecycle Management of Shards
- Federated Sharding
- What's New in Oracle Sharding 21c
- Where To Go From Here
- 2 Oracle Sharding Architecture and Concepts
- 3 Security in an Oracle Sharding Environment
-
4
Sharded Database Deployment
- Introduction to Sharded Database Deployment
- Planning Your Sharded Database Deployment
- 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
- 5 Using Oracle Database Sharding in Oracle Cloud Infrastructure
- 6 Sharded Database Schema Design
-
7
Using the Sharding Advisor
- About Sharding Advisor
- Run Sharding Advisor
- Run Sharding Advisor on a Non-Production System
- Review Sharding Advisor Output
- Choose a Sharding Advisor Recommended Configuration
- Sharding Advisor Usage and Options
- Sharding Advisor Output Tables
- Sharding Advisor Output Review SQL Examples
- Sharding Advisor Security
- 8 Migrating to a Sharded Database
-
9
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
- 10 Developing Applications for the Sharded Database
- 11 Sharding JSON Document Collections
-
12
Sharded Database Administration
- Managing the Sharding-Enabled Stack
- Managing Oracle Sharding Database Users
-
Backing Up and Recovering a Sharded Database
- Prerequisites to Configuring Centralized Backup and Restore
- Configuring Automated Backups
- Enabling and Disabling Automated Backups
- Backup Job Operation
- Monitoring Backup Status
- Viewing an Existing Backup Configuration
- Running On-Demand Backups
- Viewing Backup Job Status
- Listing Backups
- Validating Backups
- Deleting Backups
- Creating and Listing Global Restore Points
- Restoring From Backup
- Monitoring a Sharded Database
- Propagation of Parameter Settings Across Shards
- Modifying a Sharded Database Schema
- Managing Sharded Database Software Versions
- Shard Management
- Chunk Management
- Shard Director Management
- Region Management
- Shardspace Management
- Shardgroup Management
- Services Management
- 13 Troubleshooting Oracle Sharding
- 14 Oracle Sharding Solutions
- 15 Oracle Sharding Reference