Index

A

abandon connection timeout property 5.4.3
AbandonedConnectionTimeoutCallback 7.1
admin package 2.3
affinity
- transaction-based 10.4.1.1
- web session 10.4.1
application continuity
- connection initialization callback 12.4
- connection labeling 12.3
- data source configuration 12.2
Application Continuity 12.1
applyConnectionLabel 6.4
applying connection labels 6.4

B

basic connection example 2.5
benefits of connection pools 1.2
benefits of FCF 10.2.1
benefits of run-time connection load balancing 10.3.1
borrowing connections
- basic steps 2.2
- conceptual architecture 1.3.1
- labeled 6.5
- overview 3.1.1
- using JNDI 3.1.5
- using the pool-enabled data source 3.1.2
- using the pool-enabled XA data source 3.1.3

C

caching statements 5.6.1
callback
- connection affinity 10.4.2.1
- labeling 6.2.1
checking unmatched labels 6.6
closing connections 3.4
conceptual architecture 1.3.1
configure method 6.2.2
Configuring ONS 10.2.6
- client-side daemon configuration 10.2.6.3
- Remote Configuration 10.2.6.2
connection affinity
- create callback 10.4.2.1
- overview 10.4.1
- register callback 10.4.2.2
- remove callback 10.4.2.3
- setting up 10.4.2
- statistics 14.4.3
- transaction-based 10.4.1.1
- web session 10.4.1
ConnectionAffinityCallback interface 10.4.2.1
Connection Creation Consumer 4
connection factory 2.2
- conceptual architecture 1.3.1
- requirements 2.1
- setting 3.1.2, 3.1.3
ConnectionLabelingCallback interface 6.1, 6.2.2
connection labels
- apply 6.4
- check unmatched 6.6
- implement callback 6.2.1
- overview 6.1
- removing 6.7
Connection object 1.3.1
connection pool
- benefits 1.2
- create explicitly 8.1.3.1
- create implicitly 2.2, 3.1.1
- destroy 8.1.3.4
- general overview 1.1
- maintenance 8.1.4
- purge 8.1.4.3
- recycle 8.1.4.2
- refresh 8.1.4.1
- remove connection from 3.5
- start 8.1.3.2
- stop 8.1.3.3
- understanding lifecycle 8.1.3
connection pool manager
- create 8.1.2
- create pool explicitly 8.1.3.1
- destroy pool 8.1.3.4
- overview 1.3.3, 8.1.1
- purge pool 8.1.4.3
- recycle pool 8.1.4.2
- refresh pool 8.1.4.1
- start pool 8.1.3.2
- stop pool 8.1.3.3
connection pool properties
- abandon connection timeout 5.4.3
- connection wait timeout 5.4.5
- harvest maximum count 5.5.4
- harvest trigger count 5.5.3
- inactive connection timeout 5.4.6
- inactive connection timeout property 5.4.6
- initial pool size 5.2.1
- maximum connection reuse count 5.4.1.2
- maximum connection reuse time 5.4.1.1
- maximum pool size 5.2.3
- maximum statements 5.6.2
- minimum pool size 5.2.2
- optimizing 5.1
- overview 1.3.2
- setInactiveConnectionTimeout 5.4.6
- setting 3.2, 5.1
- timeout check interval 5.4.8
- timeout properties
  - inactive 5.4.6
- time-to-live connection timeout 5.4.4
- validate on borrow 3.3.1
connection properties 3.1.4
connection reuse properties, setting 5.4.1
connections
- basic steps 2.2
- borrowing 3.1.1
- borrowing labeled 6.5
- borrowing using JNDI 3.1.5
- checking if valid 3.3.3
- closing 3.4
- controlling stale 5.4
- harvesting 5.5
- labeling 6.1
- removing from the pool 3.5
- run-time load balancing 10.3.1
- using affinity 10.4.1
- validate on borrow 3.3.1
connection steps, basic 2.2
- example 2.5
connection URL 10.2.7
connection wait timeout property 5.4.5
cost method 6.2.2
create connection pool
- explicit 8.1.3.1
- implicit 2.2

D

database requirements 2.1
data source
- PoolDataSource 1.3.1, 3.1.2
- PoolXADataSource 1.3.1, 3.1.3
destroyConnectionPool 8.1.3.4
destroying a connection pool 8.1.3.4

E

enable FCF property 10.2.5
errors
- connection pool layer messages A.2
- general UCP message structure A.1
- JDBC data sources and dynamic proxies messages A.3
example
- basic connection 2.5
- connection affinity callback 10.4.2.1
- FCF 10.2.4
- labeling callback 6.2.2.1

F

fast connection failover
- prerequisites 10.2.3
Fast Connection Failover
- See: FCF
FCF
- configure connection URL 10.2.7
- configure ONS 10.2.6
- enable 10.2.5
- example 10.2.4
- statistics 14.4.1

G

GDS 10.5
getAffinityPolicy 10.4.2.1
getConnection methods 3.1.2, 6.5
getPoolDataSource 3.1.2
getPoolXADataSource 3.1.3
getStatistics 14.4
getting a connection 3.1.2
getting an XA connection 3.1.3
getUniversalConnectionPoolManager 8.1.2
getUnmatchedConnectionLabels 6.6
getXAConnection methods 3.1.3
Global Data Services 10.5

H

HarvestableConnection interface 5.5.2
harvest connections 5.5
harvest maximum count property 5.5.4
harvest trigger count property 5.5.3
high availability 1.3.4, 10.1

I

initial pool size property 5.2.1
integration
- third-party 3.6
isValid 3.3.3

J

JDBC connection pool
- See: UCP
JDBC driver
- connection properties 3.1.4
- requirements 2.1
jdbc package 2.3
JNDI 3.1.5
JRE requirements 2.1

L

LabelableConnection interface 6.1, 6.4
labeled connections
- apply label 6.4
- borrowing 6.5
- check unmatched 6.6
- implement callback 6.2.1
- overview 6.1
- remove label 6.7
labeling callback
- create 6.2.2
- example 6.2.2.1
- register 6.2.3
- removing 6.2.4
- run-time algorithm 6.2.2
lifecycle of connection pools 8.1.3
lifecycle states 8.1.3
Load Balance Advisory 10.3.1
load balancing 10.2.7, 10.3.1

M

manager, connection pool 8.1.1
maximum connection reuse count property 5.4.1.2
maximum connection reuse time property 5.4.1.1
maximum pool size property 5.2.3
maximum statements property 5.6.2
method 3.1.3
Minimal Pool configuration 2.6
minimum pool size property 5.2.2

O

ONS 10.2.6
ons.config file 10.2.6
optimizing a connection pool 5.1
Oracle Client software 10.2.6
Oracle Client software requirements 2.1
Oracle Notification Service
- See: ONS
Oracle RAC
- connection affinity 10.4.1
- features overview 10.1
- run-time connection load balancing 10.3.1
- statistics 14.4
Oracle RAC Load Balance Advisory 10.3.1
overview
- connection pool manager 8.1.1
- connection pool properties 5.1
- connection pools, general 1.1
- connection steps 2.2
- high availability and performance features 1.3.4
- labeling connections 6.1
- Oracle RAC features 10.1
- UCP 1.3

P

password 2.2, 3.1.2, 3.1.3
PoolDataSourceFactory class 3.1.2, 3.1.3
PoolDataSourceImpl 3.6
PoolDataSource interface 1.3.1, 3.1.2
pool-enabled data source
- create instance 3.1.2
pool-enabled XA data source
- create instance 3.1.3
pool manager
- See: connection pool manager
pool properties
- See: connection pool properties
pool size, controlling
- initial size 5.2.1
- maximum 5.2.3
- minimum 5.2.2
PoolXADataSourceImpl 3.6
PoolXADataSource interface 1.3.1, 3.1.3
purgeConnectionPool 8.1.4.3
purging a connection pool 8.1.4.3

R

Real Application Clusters
- See Oracle RAC 1.3
recycleConnectionPool 8.1.4.2
recycling a connection pool 8.1.4.2
refreshConnectionPool 8.1.4.1
refreshing a connection pool 8.1.4.1
registerConnectionAffinityCallback 10.4.2.2
registerConnectionLabelingCallback 6.2.3
removeConnectionAffinityCallback 10.4.2.3
removeConnectionLabel 6.7
removeConnectionLabelingCallback 6.2.4
removing connection labels 6.7
removing connections from the pool 3.5
reuse properites
- maximum count 5.4.1.2
reuse properties
- maximum time 5.4.1.1
run-time connection load balancing
- overview 10.3.1
- setting up 10.3.2
- statistics 14.4.2

S

SERVICE_TIME 10.3.2
setAbandonedConnectionTimeout 5.4.3
setAffinityPolicy 10.4.2.1
setConnectionAffinityContext 10.4.2.1
setConnectionFactoryClassName 3.1.2, 3.1.3
setConnectionHarvestable 5.5.2
setConnectionHarvestMaxCount 5.5.4
setConnectionHarvestTriggerCount 5.5.3
setConnectionProperties 3.1.4
setConnectionWaitTimeout 5.4.5
setFastConnectionFailoverEnabled 10.2.5
setInitialPoolSize 5.2.1
setInvalid 3.3.3, 3.5
setMaxConnectionReuseCount 5.4.1.2
setMaxConnectionReuseTime 5.4.1.1
setMaxPoolSize 5.2.3
setMaxStatements 5.6.2
setMinPoolSize 5.2.2
setONSConfiguration 10.2.6
setPassword 3.1.2, 3.1.3
setSQLForValidateConnection 3.3.1
setTimeoutCheckInterval 5.4.8
setTimeToLiveConnectionTimeout 5.4.4
setURL 3.1.2, 3.1.3
setUser 3.1.2, 3.1.3
setValidateConnectionOnBorrow 3.3.1
SHORT 10.3.2
SQL statement caching 5.6.1
stale connections 5.4
startConnectionPool 8.1.3.2
starting a connection pool 8.1.3.2
statement caching 5.6.1
statistics
- connection affinity 14.4.3
- FCF 14.4.1
- Oracle RAC 14.4
- run-time connection load balancing 14.4.2
stopConnectionPool 8.1.3.3
stopping a connection pool 8.1.3.3
system properties 2.4

T

third-party integration 3.6
THROUGHPUT 10.3.2
timeout check interval property 5.4.8
timeout properties
- abandon 5.4.3
- check interval 5.4.8
- time-to-live 5.4.4
- wait 5.4.5
TimeToLiveConnectionTimeoutCallback 7.2
time-to-live connection timeout property 5.4.4
transaction-based affinity 10.4.1.1

U

UCP
- basic connection steps 2.2
- conceptual architecture 1.3.1
- Oracle RAC features 10.1
- overview 1.3
UCP for JDBC
- connection pool properties 3.2, 5.1
UCP manager
- See: connection pool manager
ucp package 2.3
universal connection pool
- See: UCP
UniversalConnectionPoolManagerImpl 8.1.2
UniversalConnectionPoolManager interface 8.1.2
unmatched labels 6.6
URL 2.2, 3.1.2, 3.1.3, 10.2.7
username 2.2, 3.1.2, 3.1.3

V

validate connections
- on borrow 3.3.1
- programmatically 3.3.3
ValidConnection interface 3.3.3, 3.5

W

web session affinity 10.4.1

X

XAConnection object 1.3.1
XA connections 1.3.1, 3.1.3