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 Security in an Oracle Sharding Environment
-
4
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
- 5 Using Oracle Database Sharding in Oracle Cloud Infrastructure
-
6
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
- 7 Migrating to a Sharded Database
-
8
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
- 9 Developing Applications for the Sharded Database
-
10
Sharded Database Administration
- Managing the Sharding-Enabled Stack
- Oracle Globally Distributed Database Users and Roles
- 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
- Managing Oracle Sharded Database with Enterprise Manager Cloud Control
- Monitoring a Sharded Database
- Shard Management
- Chunk Management
- Shard Director Management
- Region Management
- Shardspace Management
- Shardgroup Management
- Services Management
-
11
Achieving Data Sovereignty with Oracle Sharding
- Overview of Data Sovereignty
- Benefits of Implementing Data Sovereignty with Oracle Sharding
- Implementing Data Sovereignty with Oracle Sharding
-
Use Case of Achieving Data Sovereignty with Oracle Sharding
- Overview of Oracle Sharding Solution
- Deployment Topology of Data Sovereignty with Oracle Sharding
-
Configuring Data Sovereignty with Oracle Sharding
- Configuring VCN Networks in All Three OCI Regions
- Configuring Remote VCN Peering Between All Three Regions
- Configuring Private DNS for Naming Resolution Between the Regions
- Installing a Global Service Manager in Each Region
- Collecting TNS entries for Shard Catalog and Sharded Databases
- Configuring the Shard Catalog
- Configuring the Shard Databases
- Creating Oracle Sharding Global Database
-
12
Troubleshooting Oracle Sharding
-
Troubleshooting Tips
- Checking the Sharding Method
- Checking the Replication Type
- Checking the Oracle Data Guard Protection Mode
- Checking Which Shards Are Mapped to a Key
- Checking Shard Operation Mode (Read-Only or Read-Write)
- Checking DDL Text
- Checking Chunk Migration Status
- Checking Table Type (Sharded or Duplicated)
- Checking User Type (Local or ALL_SHARD)
- Identifying Tables Created as Sharded Tablespaces
- Checking if Shard DDL is Enabled or Disabled
- Filtering Data by Sharding Key
- Setting the Duplicated Table Refresh Rate
- Oracle Sharding Tracing and Debug Information
- Common Error Patterns and Resolutions for Sharded Databases
-
Troubleshooting Tips
- 13 Oracle Sharding Reference