0 Replies Latest reply on Mar 27, 2013 10:08 AM by 912351

    OCI connection pooling and cleaning dead connections

      Hi all!

      I am currently using oci session pooling in my application and every 2-3 days I get "ORA-03135: Connection lost contact" and I need to restart my application to establish a new connection (this happens even after I implemented regular OCIPing every 60 seconds). Since I do not control that RAC nor I can influence any changes on it I was wondering would it help to use connection pooling from client side instead of session pooling? Would connection pool clean up connection that returns "ORA-03135: Connection lost contact" and create new one automatically? If not - is there a way to clean-up such connection manually and force connection pool to create new connection?