session timeout happening every 2 2-3 hours
Hi All,
We are having one requirement that our dedicated session to Oracle Database 10g (10.2.0.5) should not get timeout, but it is getting timeout after 2-3 hours of idle time with connection lost contact error. We have checked that oracle user which connect to database is having profile (dba_profiles) which have idle time as "UNLIMITED" , apart from that also we have checked sqlnet.ora, this file is blank. Could you plz suggest that after these setting also why connection is getting timeout. We are connecting by pl-sql developer, toad session and sqlplus and we are getting same result.
Any suggestion is welcome.
Thanks