Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Universal Connection Pool Developer's Guide
- 1 Introduction to UCP
- 2 Getting Started
- 3
Getting Database Connections in UCP
- 3.1 About Borrowing Connections from UCP
- 3.2 Setting Connection Pool Properties for UCP
- 3.3 Overview of Validating Connections in UCP
- 3.4 Returning Borrowed Connections to UCP
- 3.5 Removing Connections from UCP
- 3.6 UCP Integration with Third-Party Products
- 4
Optimizing Universal Connection Pool Behavior
- 4.1 Optimizing Connection Pools
- 4.2 About Controlling the Pool Size in UCP
- 4.3 About Optimizing Real-World Performance with Static Connection Pools
- 4.4 Stale Connections in UCP
- 4.5 About Harvesting Connections in UCP
- 4.6 About Caching SQL Statements in UCP
- 5 Labeling Connections in UCP
- 6 Controlling Reclaimable Connection Behavior
- 7 Using the Connection Pool Manager
- 8 Shared Pool Support for Multitenant Data Sources
- 9
Using Oracle RAC Features
- 9.1 Overview of Oracle RAC Features
- 9.2 About Fast Connection Failover
- 9.3 About Run-Time Connection Load Balancing
- 9.4 About Connection Affinity
- 9.5 Global Data Services
- 10 Ensuring Application Continuity
- 11
Shared Pool for Sharded Databases
- 11.1 Overview of UCP Shared Pool for Database Sharding
- 11.2
About Handling Connection Requests for a Sharded Database
- 11.2.1 About Building the Sharding Key
- 11.2.2 How to Checkout Connections from a Pool with a Sharding Key
- 11.2.3 About Checking Out Connections without Providing the Sharding Keys
- 11.2.4 About Connecting to the Shard Catalog or Co-ordinator for Multi Shard Queries
- 11.2.5 About Configuring the Number of Connections Per Shard
- 11.2.6 Pool Connection Selection Algorithm During Connection Checkout
- 11.2.7 Failover or Resharding Event Handling in UCP
- 11.3 UCP APIs for Database Sharding Support
- 11.4 UCP Sharding Example
- 12 Diagnosing a Connection Pool
- A Error Codes Reference
- Index