Skip to Main Content
  • Questions
  • Sessions disconnected automatically.

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Vicente.

Asked: August 02, 2016 - 3:59 pm UTC

Last updated: August 04, 2016 - 9:33 am UTC

Version: Oracle 11g (11.2.0.3.0)

Viewed 10K+ times! This question is

You Asked

Hi Tom.

I can't find how my database is disconnecting the inactive sessions because when I ran the following statements:

select * from user_resource_limits a
where a.resource_name in ('IDLE_TIME','CONNECT_TIME');

IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED

select profile, resource_name, limit
from dba_profiles
where resource_name ='IDLE_TIME';

DEFAULT IDLE_TIME UNLIMITED
MONITORING_PROFILE IDLE_TIME DEFAULT

I don't really know where more could I look for but every time I connect to that database after a while my sessions are disconnected and I can't find why. Could you help me with that please.

Thank you so much.

Vinny.

and Chris said...

Are you sure this is happening at the database level? Could there be anything at the application or network level which is disconnecting the sessions? Is there a firewall timeout between you and the database?

It could also be that these sessions are dying for some reason and you have Dead Client Detection enabled:

http://www.oracle.com/technetwork/database/enterprise-edition/oraclenetdcd-2179641.pdf

To verify this, check whether the SQLNET.EXPIRE_TIME is set on the database server's sqlnet.ora.

Is this answer out of date? If it is, please let us know via a Comment