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
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 Multi-Shard Query 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 Administration
- 10.1 Managing the Sharding-Enabled Stack
- 10.2 Managing Oracle Sharding Database Users
- 10.3 Monitoring a Sharded Database
- 10.4 Backing Up and Recovering a Sharded Database
- 10.5 Modifying a Sharded Database Schema
- 10.6 Propagation of Parameter Settings Across Shards
- 10.7 Managing Sharded Database Software Versions
- 10.8 Shard Management
- 10.9 Chunk Management
- 10.10 Shard Director Management
- 10.11 Region Management
- 10.12 Shardspace Management
- 10.13 Shardgroup Management
- 10.14 Services Management
- 11 Troubleshooting Oracle Sharding
- Index