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 Connection Creation Consumer
-
5
Optimizing Universal Connection Pool Behavior
- 5.1 Optimizing Connection Pools
- 5.2 About Controlling the Pool Size in UCP
- 5.3 About Optimizing Real-World Performance with Static Connection Pools
-
5.4
Stale Connections in UCP
- 5.4.1 What is Connection Reuse?
- 5.4.2 Setting the Connection Validation Timeout
- 5.4.3 Setting the Abandon Connection Timeout
- 5.4.4 Setting the Time-To-Live Connection Timeout
- 5.4.5 Setting the Connection Wait Timeout
- 5.4.6 Setting the Inactive Connection Timeout
- 5.4.7 Setting the Query Timeout
- 5.4.8 Setting the Timeout Check Interval
- 5.5 About Harvesting Connections in UCP
- 5.6 About Caching SQL Statements in UCP
- 5.7 UCP Best Practices
- 6 Labeling Connections in UCP
- 7 Controlling Reclaimable Connection Behavior
- 8 Using the Connection Pool Manager
- 9 Shared Pool Support for Multitenant Data Sources
-
10
Using Oracle RAC Features
- 10.1 Overview of Oracle RAC Features
- 10.2 About Fast Connection Failover
- 10.3 About Run-Time Connection Load Balancing
- 10.4 About Connection Affinity
- 10.5 Global Data Services
- 11 UCP Asynchronous Extension
- 12 Ensuring Application Continuity
-
13
Shared Pool for Sharded Databases
- 13.1 Overview of UCP Shared Pool for Database Sharding
-
13.2
About Handling Connection Requests for a Sharded Database
- 13.2.1 About Building the Sharding Key
- 13.2.2 How to Checkout Connections from a Pool with a Sharding Key
- 13.2.3 About Checking Out Connections without Providing the Sharding Keys
- 13.2.4 About Connecting to the Shard Catalog or Co-ordinator for Multi Shard Queries
- 13.2.5 About Configuring the Number of Connections Per Shard
- 13.2.6 Pool Connection Selection Algorithm During Connection Checkout
- 13.2.7 Failover or Resharding Event Handling in UCP
- 13.3 Sharding Data Source for Transparent Access to Sharded Databases
- 13.4 UCP APIs for Database Sharding Support
- 13.5 UCP Sharding Example
- 13.6 Middle-Tier Routing Using UCP
- 13.7 Sharding with JTA/XA Transaction in WebLogic Server
- 14 Diagnosing a Connection Pool
- A Error Codes Reference
- B UCP Exception Error Codes
- Index