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
- 14 Diagnosing a Connection Pool
- A Error Codes Reference
- B UCP Exception Error Codes
- Index