I am using a java file to connect to the oracle database to retrieve some information and write it in to a file. I am just using select command to retrieve the data. There are no locks on the database (tables) and CPU utility is also normal. But while executing the program, after some time the connection is getting lost and my java program is still running.
At the database end the SID is getting killed automatically after some time. That query actually takes some one and half hours to complete. Is there any concept of killing the session after some time if it is idle?