Table of Contents
- Title and Copyright Information
- Preface
- 1 Introduction to UCP
- 2 Getting Started
-
3
Getting Database Connections in UCP
- About Borrowing Connections from UCP
- Setting Connection Pool Properties for UCP
- Overview of Validating Connections in UCP
- Returning Borrowed Connections to UCP
- Removing Connections from UCP
- UCP Integration with Third-Party Products
-
4
Optimizing Universal Connection Pool Behavior
- Optimizing Connection Pools
- About Controlling the Pool Size in UCP
- About Optimizing Real-World Performance with Static Connection Pools
- Stale Connections in UCP
- About Harvesting Connections in UCP
- About Caching SQL Statements in UCP
- UCP Best Practices
- 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
- Overview of Oracle RAC Features
- About Fast Connection Failover
- About Run-Time Connection Load Balancing
- About Connection Affinity
- Global Data Services
- 10 Ensuring Application Continuity
-
11
Shared Pool for Sharded Databases
- Overview of UCP Shared Pool for Database Sharding
-
About Handling Connection Requests for a Sharded Database
- About Building the Sharding Key
- How to Checkout Connections from a Pool with a Sharding Key
- About Checking Out Connections without Providing the Sharding Keys
- About Connecting to the Shard Catalog or Co-ordinator for Multi Shard Queries
- About Configuring the Number of Connections Per Shard
- Pool Connection Selection Algorithm During Connection Checkout
- Failover or Resharding Event Handling in UCP
- Sharding Data Source for Transparent Access to Sharded Databases
- Middle-Tier Routing Using UCP
- UCP APIs for Database Sharding Support
- UCP APIs for Middle-Tier Routing Support
- UCP Sharding Example
- Middle-Tier Routing with UCP Example
- 12 Diagnosing a Connection Pool
- A Error Codes Reference
- Index