Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Sharding
- 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
Routing in an SDB Environment
- 6.1 Direct Routing to a Shard
-
6.2
Queries and DMLs with Proxy Routing in an SDB
- 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
- 7 Shard-Level High Availability
-
8
Sharded Database Deployment
- 8.1 Introduction to SDB 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 SDB
- 8.8 Creating and Deploying a User-Defined SDB
- 8.9 Creating and Deploying a Composite SDB
-
9
Sharded Database Lifecycle Management
- 9.1 Managing the Sharding-Enabled Stack
- 9.2 Monitoring a Sharded Database
- 9.3 Backing Up and Recovering a Sharded Database
- 9.4 Modifying a Sharded Database Schema
- 9.5 Managing Sharded Database Software Versions
- 9.6 Shard Management
- 9.7 Chunk Management
- 9.8 Shard Director Management
- 9.9 Region Management
- 9.10 Shardspace Management
- 9.11 Shardgroup Management
- 9.12 Services Management
- 10 Troubleshooting Oracle Sharding
- Index