Recently, there are customers in the application of the system has a frequent automatic disconnection of the database (every 10 minutes) of the anomaly, through the search for learning, find the following two ways to solve. For everyone's reference.
Three steps to complete in a sqlplus environment.
The first step is to query the resource file and find the profile name where Connect_time is located.
select Resource_name,profile from Dba_profiles;
The second step is to modify the value in the profile with the ALTER command;
alter profile monitoring_profile limit Connect_time unlimited; (or with a time value, such as 1000, in minutes)
alter profile monitoring_profile limit Idle_time unlimited;
The third step is to view the values in the profile with the following command;
Select Resource_name,limit from dba_profiles where profile= ' monitoring_profile ';
Oracle Auto-Disconnect database connection workaround