0 Replies Latest reply: Mar 27, 2013 5:08 AM by 912351 RSS

    OCI connection pooling and cleaning dead connections

    912351
      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?

      BR,
      Ivan