Oracle Connection Pool Drops

[paulsa3598]

Hi,

We are currently using connection pools and JDBC to connect between the DB and clients. The problem that keeps occuring as that these connections get dropped if they aren't used. I believe what is happening is since some of these connections are not used from the pool they get dropped because the connection has expired within the PIX table although there are other connections from the Oracles/JDBC connection pool. Using a smaller pool is not an option because at times we use all the connections allocated in the pool.

Does the PIX have a way around this? If not any other suggestions?

[a-vazquez]

There is an option to set the PIX connection timeout. May be you can try setting the connection timeout that is close to the JDBC connection timeout.

[paulsa3598]

We are trying to avoid increasing the connection timeouts. It is already at the defaults which are too long to begin with.