Index

A

abandon connection timeout property 4.4.3
AbandonedConnectionTimeoutCallback 6.1
admin package 2.3
affinity
- transaction-based 9.4.1.1
- web session 9.4.1
API overview 2.3
application continuity
- connection initialization callback 10.4
- connection labeling 10.3
- data source configuration 10.2
Application Continuity 10.1
applyConnectionLabel 5.4
applying connection labels 5.4

B

basic connection example 2.4
benefits of connection pools 1.2
benefits of FCF 9.2.1
benefits of run-time connection load balancing 9.3.1
borrowing connections
- basic steps 2.2
- conceptual architecture 1.3.1
- labeled 5.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 4.6.1
callback
- connection affinity 9.4.2.1
- labeling 5.2.1
checking unmatched labels 5.6
closing connections 3.4
conceptual architecture 1.3.1
configure method 5.2.2
Configuring ONS 9.2.6
- client-side daemon configuration 9.2.6.3
- Remote Configuration 9.2.6.2
connection affinity
- create callback 9.4.2.1
- overview 9.4.1
- register callback 9.4.2.2
- remove callback 9.4.2.3
- setting up 9.4.2
- statistics 12.3.3
- transaction-based 9.4.1.1
- web session 9.4.1
ConnectionAffinityCallback interface 9.4.2.1
connection factory 2.2
- conceptual architecture 1.3.1
- requirements 2.1
- setting 3.1.2, 3.1.3
ConnectionLabelingCallback interface 5.1, 5.2.2
connection labels
- apply 5.4
- check unmatched 5.6
- implement callback 5.2.1
- overview 5.1
- removing 5.7
Connection object 1.3.1
connection pool
- benefits 1.2
- create explicitly 7.1.3.1
- create implicitly 2.2, 3.1.1
- destroy 7.1.3.4
- general overview 1.1
- maintenance 7.1.4
- purge 7.1.4.3
- recycle 7.1.4.2
- refresh 7.1.4.1
- remove connection from 3.5
- start 7.1.3.2
- stop 7.1.3.3
- understanding lifecycle 7.1.3
connection pool manager
- create 7.1.2
- create pool explicitly 7.1.3.1
- destroy pool 7.1.3.4
- overview 1.3.3, 7.1.1
- purge pool 7.1.4.3
- recycle pool 7.1.4.2
- refresh pool 7.1.4.1
- start pool 7.1.3.2
- stop pool 7.1.3.3
connection pool properties
- abandon connection timeout 4.4.3
- connection wait timeout 4.4.5
- harvest maximum count 4.5.4
- harvest trigger count 4.5.3
- inactive connection timeout 4.4.6
- initial pool size 4.2.1
- maximum connection reuse count 4.4.1.2
- maximum connection reuse time 4.4.1.1
- maximum pool size 4.2.3
- maximum statements 4.6.2
- minimum pool size 4.2.2
- optimizing 4.1
- overview 1.3.2
- setting 3.2, 4.1
- timeout check interval 4.4.8
- time-to-live connection timeout 4.4.4
- validate on borrow 3.3.1
connection properties 3.1.4
connection reuse properties, setting 4.4.1
connections
- basic steps 2.2
- borrowing 3.1.1
- borrowing labeled 5.5
- borrowing using JNDI 3.1.5
- checking if valid 3.3.3
- closing 3.4
- controlling stale 4.4
- harvesting 4.5
- labeling 5.1
- removing from the pool 3.5
- run-time load balancing 9.3.1
- using affinity 9.4.1
- validate on borrow 3.3.1
connection steps, basic 2.2
- example 2.4
connection URL 9.2.7
connection wait timeout property 4.4.5
cost method 5.2.2
create connection pool
- explicit 7.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 7.1.3.4
destroying a connection pool 7.1.3.4

E

enable FCF property 9.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.4
- connection affinity callback 9.4.2.1
- FCF 9.2.4
- labeling callback 5.2.2.1

F

FAN 9.2.1
fast connection failover
- prerequisites 9.2.3
Fast Connection Failover
- See: FCF
FCF 9.2.1
- configure connection URL 9.2.7
- configure ONS 9.2.6
- enable 9.2.5
- example 9.2.4
- statistics 12.3.1

G

GDS 9.5
getAffinityPolicy 9.4.2.1
getConnection methods 3.1.2, 5.5
getPoolDataSource 3.1.2
getPoolXADataSource 3.1.3
getStatistics 12.3
getting a connection 3.1.2
getting an XA connection 3.1.3
getUniversalConnectionPoolManager 7.1.2
getUnmatchedConnectionLabels 5.6
getXAConnection methods 3.1.3
Global Data Services 9.5

H

HarvestableConnection interface 4.5.2
harvest connections 4.5
harvest maximum count property 4.5.4
harvest trigger count property 4.5.3
high availability 1.3.4, 9.1

I

inactive connection timeout property 4.4.6
initial pool size property 4.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 5.1, 5.4
labeled connections
- apply label 5.4
- borrowing 5.5
- check unmatched 5.6
- implement callback 5.2.1
- overview 5.1
- remove label 5.7
labeling callback
- create 5.2.2
- example 5.2.2.1
- register 5.2.3
- removing 5.2.4
- run-time algorithm 5.2.2
lifecycle of connection pools 7.1.3
lifecycle states 7.1.3
Load Balance Advisory 9.3.1
load balancing 9.2.7, 9.3.1
logging 12.4
logging configuration
- programmatically 12.4.2
- properties file 12.4.1
logging levels 12.4.5

M

manager, connection pool 7.1.1
maximum connection reuse count property 4.4.1.2
maximum connection reuse time property 4.4.1.1
maximum pool size property 4.2.3
maximum statements property 4.6.2
method 3.1.3
minimum pool size property 4.2.2

O

ONS 9.2.6
ons.config file 9.2.6
optimizing a connection pool 4.1
Oracle Client software 9.2.6
Oracle Client software requirements 2.1
Oracle Notification Service
- See: ONS
Oracle RAC
- connection affinity 9.4.1
- FCF 9.2.1
- features overview 9.1
- run-time connection load balancing 9.3.1
- statistics 12.3
Oracle RAC Load Balance Advisory 9.3.1
overview
- API 2.3
- connection pool manager 7.1.1
- connection pool properties 4.1
- connection pools, general 1.1
- connection steps 2.2
- high availability and performance features 1.3.4
- labeling connections 5.1
- Oracle RAC features 9.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 4.2.1
- maximum 4.2.3
- minimum 4.2.2
PoolXADataSourceImpl 3.6
PoolXADataSource interface 1.3.1, 3.1.3
purgeConnectionPool 7.1.4.3
purging a connection pool 7.1.4.3

R

Real Application Clusters
- See Oracle RAC 1.3
recycleConnectionPool 7.1.4.2
recycling a connection pool 7.1.4.2
refreshConnectionPool 7.1.4.1
refreshing a connection pool 7.1.4.1
registerConnectionAffinityCallback 9.4.2.2
registerConnectionLabelingCallback 5.2.3
removeConnectionAffinityCallback 9.4.2.3
removeConnectionLabel 5.7
removeConnectionLabelingCallback 5.2.4
removing connection labels 5.7
removing connections from the pool 3.5
reuse properites
- maximum count 4.4.1.2
reuse properties
- maximum time 4.4.1.1
run-time connection load balancing
- overview 9.3.1
- setting up 9.3.2
- statistics 12.3.2

S

SERVICE_TIME 9.3.2
setAbandonedConnectionTimeout 4.4.3
setAffinityPolicy 9.4.2.1
setConnectionAffinityContext 9.4.2.1
setConnectionFactoryClassName 3.1.2, 3.1.3
setConnectionHarvestable 4.5.2
setConnectionHarvestMaxCount 4.5.4
setConnectionHarvestTriggerCount 4.5.3
setConnectionProperties 3.1.4
setConnectionWaitTimeout 4.4.5
setFastConnectionFailoverEnabled 9.2.5
setInactiveConnectionTimeout 4.4.6
setInitialPoolSize 4.2.1
setInvalid 3.3.3, 3.5
setMaxConnectionReuseCount 4.4.1.2
setMaxConnectionReuseTime 4.4.1.1
setMaxPoolSize 4.2.3
setMaxStatements 4.6.2
setMinPoolSize 4.2.2
setONSConfiguration 9.2.6
setPassword 3.1.2, 3.1.3
setSQLForValidateConnection 3.3.1
setTimeoutCheckInterval 4.4.8
setTimeToLiveConnectionTimeout 4.4.4
setURL 3.1.2, 3.1.3
setUser 3.1.2, 3.1.3
setValidateConnectionOnBorrow 3.3.1
SHORT 9.3.2
SQL statement caching 4.6.1
stale connections 4.4
startConnectionPool 7.1.3.2
starting a connection pool 7.1.3.2
statement caching 4.6.1
statistics
- connection affinity 12.3.3
- FCF 12.3.1
- Oracle RAC 12.3
- run-time connection load balancing 12.3.2
stopConnectionPool 7.1.3.3
stopping a connection pool 7.1.3.3

T

third-party integration 3.6
THROUGHPUT 9.3.2
timeout check interval property 4.4.8
timeout properties
- abandon 4.4.3
- check interval 4.4.8
- inactive 4.4.6
- time-to-live 4.4.4
- wait 4.4.5
TimeToLiveConnectionTimeoutCallback 6.2
time-to-live connection timeout property 4.4.4
transaction-based affinity 9.4.1.1

U

UCP
- API overview 2.3
- basic connection steps 2.2
- conceptual architecture 1.3.1
- Oracle RAC features 9.1
- overview 1.3
- software requirements 2.1
UCP for JDBC
- connection pool properties 3.2, 4.1
UCP manager
- See: connection pool manager
ucp package 2.3
universal connection pool
- See: UCP
UniversalConnectionPoolManagerImpl 7.1.2
UniversalConnectionPoolManager interface 7.1.2
unmatched labels 5.6
URL 2.2, 3.1.2, 3.1.3, 9.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 9.4.1

X

XAConnection object 1.3.1
XA connections 1.3.1, 3.1.3