5 Replies Latest reply: Feb 13, 2014 8:19 AM by garywicke RSS

How to audit a closed DB connection due to timeout?

garywicke Newbie
Currently Being Moderated


Oracle EE on Solaris 10

I have an environment where a Pentaho instance is loading data into the Oracle database.  The load action opens a database connection, reads some data and then takes a long time (60-90 minutes) to process the data and then attempts to write the data to the database using the same connection.

We are seeing a timeout error: "Io exception: Connection timed out"   coming out of Pentaho after about 60 minutes.


I have the following settings in SQLNET.ORA:



The firewall settings have been verified to not include anything that would terminate a connection after 60 minutes.

I would like to learn more about the disconnection that seems to be happening from the database side.

What auditing option/command/setting can be sued to gather more detail about when the database senses a disconnected or idle process and hence terminates the connection?

Thanks very much!!



  • Correct Answers - 10 points
  • Helpful Answers - 5 points