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.4.1 What is Connection Reuse?
- 4.4.2 Setting the Connection Validation Timeout
- 4.4.3 Setting the Abandon Connection Timeout
- 4.4.4 Setting the Time-To-Live Connection Timeout
- 4.4.5 Setting the Connection Wait Timeout
- 4.4.6 Setting the Inactive Connection Timeout
- 4.4.7 Setting the Query Timeout
- 4.4.8 Setting the Timeout Check Interval
- 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 Middle-Tier Routing Using UCP
- 11.4 UCP APIs for Database Sharding Support
- 11.5 UCP APIs for Middle-Tier Routing Support
- 11.6 UCP Sharding Example
- 11.7 Middle-Tier Routing with UCP Example
- 12 Diagnosing a Connection Pool
- A Error Codes Reference
- Index