Index

A B C D E F G H I J L M O P R S T U V W X

A

abandon connection timeout property, 4.3.2

AbandonedConnectionTimeoutCallback, 6.1

admin package, 2.4

affinity

transaction-based, 8.4

web session, 8.4

API overview, 2.4

applyConnectionLabel, 5.3

applying connection labels, 5.3

B

basic connection example, 2.3

benefits of connection pools, 1.1.1

benefits of FCF, 8.2

benefits of run-time connection load balancing, 8.3

borrowing connections

basic steps, 2.2

conceptual architecture, 1.2.1

labeled, 5.4

overview, 3.1

using JNDI, 3.1.4

using the pool-enabled data source, 3.1.1

using the pool-enabled XA data source, 3.1.2

C

caching statements, 4.5

callback

connection affinity, 8.4.1.1

labeling, 5.2

checking unmatched labels, 5.5

closing connections, 3.4

conceptual architecture, 1.2.1

configure method, 5.2.1

configure ONS, 8.2.3

connection affinity

create callback, 8.4.1.1

overview, 8.4

remove callback, 8.4.1.3

setting up, 8.4.1

statistics, 9.3.3

transaction-based, 8.4

web session, 8.4

connection factory, 2.2

conceptual architecture, 1.2.1

requirements, 2.1

setting, 3.1.1, 3.1.2

connection labels

apply, 5.3

check unmatched, 5.5

implement callback, 5.2

overview, 5.1

removing, 5.6

Connection object, 1.2.1

connection pool

benefits, 1.1.1

create explicitly, 7.1.3.1

create implicitly, 2.2, 3.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.2.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.3.2

connection wait timeout, 4.3.4

harvest maximum count, 4.4.3

harvest trigger count, 4.4.2

inactive connection timeout, 4.3.5

initial pool size, 4.2.1

maximum connection reuse count, 4.3.1.2

maximum connection reuse time, 4.3.1.1

maximum pool size, 4.2.3

maximum statements, 4.5.1

minimum pool size, 4.2.2

optimizing, 4.1

overview, 1.2.2

setting, 3.2, 4.1

timeout check interval, 4.3.6

time-to-live connection timeout, 4.3.3

validate on borrow, 3.3.1

connection properties, 3.1.3

connection reuse properties, setting, 4.3.1

connection steps, basic, 2.2

example, 2.3

connection URL, 8.2.4

connection wait timeout property, 4.3.4

ConnectionAffinityCallback interface, 8.4.1.1

ConnectionLabelingCallback interface, 5.1, 5.2.1

connections

basic steps, 2.2

borrowing, 3.1

borrowing labeled, 5.4

borrowing using JNDI, 3.1.4

checking if valid, 3.3.2

closing, 3.4

controlling stale, 4.3

harvesting, 4.4

labeling, 5.1

removing from the pool, 3.5

run-time load balancing, 8.3

using affinity, 8.4

validate on borrow, 3.3.1

cost method, 5.2.1

create connection pool

explicit, 7.1.3.1

implicit, 2.2

D

data source

PoolDataSource, 1.2.1, 3.1.1

PoolXADataSource, 1.2.1, 3.1.2

database requirements, 2.1

destroyConnectionPool, 7.1.3.4

destroying a connection pool, 7.1.3.4

E

enable FCF property, 8.2.2

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.3

connection affinity callback, 8.4.1.1

FCF, 8.2.1

labeling callback, 5.2.1.1

F

FAN, 8.2

Fast Connection Failover

See FCF

FCF, 8.2

configure connection URL, 8.2.4

configure ONS, 8.2.3

enable, 8.2.2

example, 8.2.1

statistics, 9.3.1

G

getAffinityPolicy, 8.4.1.1

getConnection methods, 3.1.1, 5.4

getPoolDataSource, 3.1.1

getPoolXADataSource, 3.1.2

getStatistics, 9.3

getting a connection, 3.1.1

getting an XA connection, 3.1.2

getUniversalConnectionPoolManager, 7.1.2

getUnmatchedConnectionLabels, 5.5

getXAConnection methods, 3.1.2

H

harvest connections, 4.4

harvest maximum count property, 4.4.3

harvest trigger count property, 4.4.2

HarvestableConnection interface, 4.4.1

high availability, 1.2.4, 8.1

I

inactive connection timeout property, 4.3.5

initial pool size property, 4.2.1

integration

third-party, 3.6

isValid, 3.3.2

J

JDBC connection pool

See UCP for JDBC

JDBC driver

connection properties, 3.1.3

requirements, 2.1

jdbc package, 2.4

JNDI, 3.1.4

JRE requirements, 2.1

L

LabelableConnection interface, 5.1, 5.3

labeled connections

apply label, 5.3

borrowing, 5.4

check unmatched, 5.5

implement callback, 5.2

overview, 5.1

remove label, 5.6

labeling callback

create, 5.2.1

example, 5.2.1.1

removing, 5.2.3

run-time algorithm, 5.2.1

lifecycle of connection pools, 7.1.3

lifecycle states, 7.1.3

Load Balance Advisory, 8.3

load balancing, 8.2.4, 8.3

logging, 9.4

logging configuration

programmatically, 9.4.2

properties file, 9.4.1

logging levels, 9.4.3

M

manager, connection pool, 7.1.1

maximum connection reuse count property, 4.3.1.2

maximum connection reuse time property, 4.3.1.1

maximum pool size property, 4.2.3

maximum statements property, 4.5.1

method, 3.1.2

minimum pool size property, 4.2.2

O

ONS, 8.2.3

ons.config file, 8.2.3

optimizing a connection pool, 4.1

Oracle Client software, 8.2.3

Oracle Client software requirements, 2.1

Oracle Notification Service

See ONS

overview

API, 2.4

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.2.4

labeling connections, 5.1

RAC features, 8.1

UCP for JDBC, 1.2

P

password, 2.2, 3.1.1, 3.1.2

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

PoolDataSource interface, 1.2.1, 3.1.1

PoolDataSourceFactory class, 3.1.1, 3.1.2

PoolDataSourceImpl, 3.6

pool-enabled data source

create instance, 3.1.1

pool-enabled XA data source

create instance, 3.1.2

PoolXADataSource interface, 1.2.1, 3.1.2

PoolXADataSourceImpl, 3.6

purgeConnectionPool, 7.1.4.3

purging a connection pool, 7.1.4.3

R

RAC

connection affinity, 8.4

FCF, 8.2

features overview, 8.1

run-time connection load balancing, 8.3

statistics, 9.3

RAC Load Balance Advisory, 8.3

Real Application Clusters

See RAC

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, 8.4.1.2

registerConnectionLabelingCallback, 5.2.2

removeConnectionAffinityCallback, 8.4.1.3

removeConnectionLabel, 5.6

removeConnectionLabelingCallback, 5.2.3

removing connection labels, 5.6

removing connections from the pool, 3.5

reuse properites

maximum count, 4.3.1.2

reuse properties

maximum time, 4.3.1.1

run-time connection load balancing

overview, 8.3

setting up, 8.3.1

statistics, 9.3.2

S

SERVICE_TIME, 8.3.1

setAbandonConnectionTimeout, 4.3.2

setAffinityPolicy, 8.4.1.1

setConnectionAffinityContext, 8.4.1.1

setConnectionFactoryClassName, 3.1.1, 3.1.2

setConnectionHarvestable, 4.4.1

setConnectionHarvestMaxCount, 4.4.3

setConnectionHarvestTriggerCount, 4.4.2

setConnectionProperties, 3.1.3

setConnectionWaitTimeout, 4.3.4

setFastConnectionFailoverEnabled, 8.2.2

setInactiveConnectionTimeout, 4.3.5

setInitialPoolSize, 4.2.1

setInvalid, 3.3.2, 3.5

setMaxConnectionReuseCount, 4.3.1.2

setMaxConnectionReuseTime, 4.3.1.1

setMaxPoolSize, 4.2.3

setMaxStatements, 4.5.1

setMinPoolSize, 4.2.2

setONSConfiguration, 8.2.3

setPassword, 3.1.1, 3.1.2

setSQLForValidateConnection, 3.3.1

setTimeToLiveConnectionTimeout, 4.3.3

setTimoutCheckInterval, 4.3.6

setURL, 3.1.1, 3.1.2

setUser, 3.1.1, 3.1.2

setValidateConnectionOnBorrow, 3.3.1

SHORT, 8.3.1

SQL statement caching, 4.5

stale connections, 4.3

startConnectionPool, 7.1.3.2

starting a connection pool, 7.1.3.2

statement caching, 4.5

statistics

connection affinity, 9.3.3

FCF, 9.3.1

RAC, 9.3

run-time connection load balancing, 9.3.2

stopConnectionPool, 7.1.3.3

stopping a connection pool, 7.1.3.3

T

third-party integration, 3.6

THROUGHPUT, 8.3.1

timeout check interval property, 4.3.6

timeout properties

abandon, 4.3.2

check interval, 4.3.6

inactive, 4.3.5

time-to-live, 4.3.3

wait, 4.3.4

time-to-live connection timeout property, 4.3.3

TimeToLiveConnectionTimeoutCallback, 6.2

transaction-based affinity, 8.4

U

UCP for JDBC

API overview, 2.4

basic connection steps, 2.2

conceptual architecture, 1.2.1

connection pool manager

connection pool properties, 3.2, 4.1

overview, 1.2

RAC features, 8.1

software requirements, 2.1

UCP manager

See connection pool manager

ucp package, 2.4

universal connection pool

See UCP for JDBC

UniversalConnectionPoolManager interface, 7.1.2

UniversalConnectionPoolManagerImpl, 7.1.2

unmatched labels, 5.5

URL, 2.2, 3.1.1, 3.1.2, 8.2.4

username, 2.2, 3.1.1, 3.1.2

V

validate connections

on borrow, 3.3.1

programmatically, 3.3.2

ValidConnection interface, 3.3.2, 3.5

W

web session affinity, 8.4

X

XA connections, 1.2.1, 3.1.2

XAConnection object, 1.2.1